{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Covariance Matrix of assets (solution)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: numpy==1.14.5 in /opt/conda/lib/python3.6/site-packages (from -r requirements.txt (line 1))\n",
      "Requirement already satisfied: pandas==0.18.1 in /opt/conda/lib/python3.6/site-packages (from -r requirements.txt (line 2))\n",
      "Requirement already satisfied: plotly==2.2.3 in /opt/conda/lib/python3.6/site-packages (from -r requirements.txt (line 3))\n",
      "Requirement already satisfied: scikit-learn==0.19.1 in /opt/conda/lib/python3.6/site-packages (from -r requirements.txt (line 4))\n",
      "Requirement already satisfied: six==1.11.0 in /opt/conda/lib/python3.6/site-packages (from -r requirements.txt (line 5))\n",
      "Requirement already satisfied: zipline===1.2.0 in /opt/conda/lib/python3.6/site-packages (from -r requirements.txt (line 6))\n",
      "Requirement already satisfied: pytz>=2011k in /opt/conda/lib/python3.6/site-packages (from pandas==0.18.1->-r requirements.txt (line 2))\n",
      "Requirement already satisfied: python-dateutil>=2 in /opt/conda/lib/python3.6/site-packages (from pandas==0.18.1->-r requirements.txt (line 2))\n",
      "Requirement already satisfied: decorator>=4.0.6 in /opt/conda/lib/python3.6/site-packages (from plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: nbformat>=4.2 in /opt/conda/lib/python3.6/site-packages (from plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: requests in /opt/conda/lib/python3.6/site-packages (from plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: networkx<2.0,>=1.9.1 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: empyrical>=0.4.2 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: multipledispatch>=0.4.8 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: patsy>=0.4.0 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: lru-dict>=1.1.4 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: sqlalchemy>=1.0.8 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: Logbook>=0.12.5 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: alembic>=0.7.7 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: intervaltree>=2.1.0 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: bcolz<1,>=0.12.1 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: numexpr>=2.6.1 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: tables>=3.3.0 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: MarkupSafe>=0.23 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: statsmodels>=0.6.1 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: click>=4.0.0 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: pip>=7.1.0 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: requests-file>=1.4.1 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: toolz>=0.8.2 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: cyordereddict>=0.2.2 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: Mako>=1.0.1 in /opt/conda/lib/python3.6/site-packages/Mako-1.0.7-py3.6.egg (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: scipy>=0.17.1 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: Cython>=0.25.2 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: setuptools>18.0 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: bottleneck>=1.0.0 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: sortedcontainers>=1.4.4 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: pandas-datareader<0.6,>=0.2.1 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: contextlib2>=0.4.0 in /opt/conda/lib/python3.6/site-packages (from zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: jupyter-core in /opt/conda/lib/python3.6/site-packages (from nbformat>=4.2->plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: traitlets>=4.1 in /opt/conda/lib/python3.6/site-packages (from nbformat>=4.2->plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: jsonschema!=2.5.0,>=2.4 in /opt/conda/lib/python3.6/site-packages (from nbformat>=4.2->plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: ipython-genutils in /opt/conda/lib/python3.6/site-packages (from nbformat>=4.2->plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /opt/conda/lib/python3.6/site-packages (from requests->plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: idna<2.7,>=2.5 in /opt/conda/lib/python3.6/site-packages (from requests->plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: urllib3<1.23,>=1.21.1 in /opt/conda/lib/python3.6/site-packages (from requests->plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /opt/conda/lib/python3.6/site-packages (from requests->plotly==2.2.3->-r requirements.txt (line 3))\n",
      "Requirement already satisfied: python-editor>=0.3 in /opt/conda/lib/python3.6/site-packages (from alembic>=0.7.7->zipline===1.2.0->-r requirements.txt (line 6))\n",
      "Requirement already satisfied: requests-ftp in /opt/conda/lib/python3.6/site-packages (from pandas-datareader<0.6,>=0.2.1->zipline===1.2.0->-r requirements.txt (line 6))\n",
      "\u001b[33mYou are using pip version 9.0.1, however version 18.1 is available.\n",
      "You should consider upgrading via the 'pip install --upgrade pip' command.\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "import sys\n",
    "!{sys.executable} -m pip install -r requirements.txt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import time\n",
    "import os\n",
    "import quiz_helper\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "plt.style.use('ggplot')\n",
    "plt.rcParams['figure.figsize'] = (14, 8)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### data bundle"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import quiz_helper\n",
    "from zipline.data import bundles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data Registered\n"
     ]
    }
   ],
   "source": [
    "os.environ['ZIPLINE_ROOT'] = os.path.join(os.getcwd(), '..', '..','data','module_4_quizzes_eod')\n",
    "ingest_func = bundles.csvdir.csvdir_equities(['daily'], quiz_helper.EOD_BUNDLE_NAME)\n",
    "bundles.register(quiz_helper.EOD_BUNDLE_NAME, ingest_func)\n",
    "print('Data Registered')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Build pipeline engine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "from zipline.pipeline import Pipeline\n",
    "from zipline.pipeline.factors import AverageDollarVolume\n",
    "from zipline.utils.calendars import get_calendar\n",
    "\n",
    "universe = AverageDollarVolume(window_length=120).top(500) \n",
    "trading_calendar = get_calendar('NYSE') \n",
    "bundle_data = bundles.load(quiz_helper.EOD_BUNDLE_NAME)\n",
    "engine = quiz_helper.build_pipeline_engine(bundle_data, trading_calendar)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### View Data¶\n",
    "With the pipeline engine built, let's get the stocks at the end of the period in the universe we're using. We'll use these tickers to generate the returns data for the our risk model."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[Equity(0 [A]),\n",
       " Equity(1 [AAL]),\n",
       " Equity(2 [AAP]),\n",
       " Equity(3 [AAPL]),\n",
       " Equity(4 [ABBV]),\n",
       " Equity(5 [ABC]),\n",
       " Equity(6 [ABT]),\n",
       " Equity(7 [ACN]),\n",
       " Equity(8 [ADBE]),\n",
       " Equity(9 [ADI]),\n",
       " Equity(10 [ADM]),\n",
       " Equity(11 [ADP]),\n",
       " Equity(12 [ADS]),\n",
       " Equity(13 [ADSK]),\n",
       " Equity(14 [AEE]),\n",
       " Equity(15 [AEP]),\n",
       " Equity(16 [AES]),\n",
       " Equity(17 [AET]),\n",
       " Equity(18 [AFL]),\n",
       " Equity(19 [AGN]),\n",
       " Equity(20 [AIG]),\n",
       " Equity(21 [AIV]),\n",
       " Equity(22 [AIZ]),\n",
       " Equity(23 [AJG]),\n",
       " Equity(24 [AKAM]),\n",
       " Equity(25 [ALB]),\n",
       " Equity(26 [ALGN]),\n",
       " Equity(27 [ALK]),\n",
       " Equity(28 [ALL]),\n",
       " Equity(29 [ALLE]),\n",
       " Equity(30 [ALXN]),\n",
       " Equity(31 [AMAT]),\n",
       " Equity(32 [AMD]),\n",
       " Equity(33 [AME]),\n",
       " Equity(34 [AMG]),\n",
       " Equity(35 [AMGN]),\n",
       " Equity(36 [AMP]),\n",
       " Equity(37 [AMT]),\n",
       " Equity(38 [AMZN]),\n",
       " Equity(39 [ANDV]),\n",
       " Equity(40 [ANSS]),\n",
       " Equity(41 [ANTM]),\n",
       " Equity(42 [AON]),\n",
       " Equity(43 [AOS]),\n",
       " Equity(44 [APA]),\n",
       " Equity(45 [APC]),\n",
       " Equity(46 [APD]),\n",
       " Equity(47 [APH]),\n",
       " Equity(48 [ARE]),\n",
       " Equity(49 [ARNC]),\n",
       " Equity(50 [ATVI]),\n",
       " Equity(51 [AVB]),\n",
       " Equity(52 [AVGO]),\n",
       " Equity(53 [AVY]),\n",
       " Equity(54 [AWK]),\n",
       " Equity(55 [AXP]),\n",
       " Equity(56 [AYI]),\n",
       " Equity(57 [AZO]),\n",
       " Equity(58 [BA]),\n",
       " Equity(59 [BAC]),\n",
       " Equity(60 [BAX]),\n",
       " Equity(61 [BBT]),\n",
       " Equity(62 [BBY]),\n",
       " Equity(63 [BCR]),\n",
       " Equity(64 [BDX]),\n",
       " Equity(65 [BEN]),\n",
       " Equity(66 [BIIB]),\n",
       " Equity(67 [BK]),\n",
       " Equity(68 [BLK]),\n",
       " Equity(69 [BLL]),\n",
       " Equity(70 [BMY]),\n",
       " Equity(71 [BSX]),\n",
       " Equity(72 [BWA]),\n",
       " Equity(73 [BXP]),\n",
       " Equity(74 [C]),\n",
       " Equity(75 [CA]),\n",
       " Equity(76 [CAG]),\n",
       " Equity(77 [CAH]),\n",
       " Equity(78 [CAT]),\n",
       " Equity(79 [CB]),\n",
       " Equity(80 [CBG]),\n",
       " Equity(81 [CBOE]),\n",
       " Equity(82 [CBS]),\n",
       " Equity(83 [CCI]),\n",
       " Equity(84 [CCL]),\n",
       " Equity(85 [CELG]),\n",
       " Equity(86 [CERN]),\n",
       " Equity(87 [CF]),\n",
       " Equity(88 [CFG]),\n",
       " Equity(89 [CHD]),\n",
       " Equity(90 [CHK]),\n",
       " Equity(91 [CHRW]),\n",
       " Equity(92 [CHTR]),\n",
       " Equity(93 [CI]),\n",
       " Equity(94 [CINF]),\n",
       " Equity(95 [CL]),\n",
       " Equity(96 [CLX]),\n",
       " Equity(97 [CMA]),\n",
       " Equity(98 [CMCSA]),\n",
       " Equity(99 [CME]),\n",
       " Equity(100 [CMG]),\n",
       " Equity(101 [CMI]),\n",
       " Equity(102 [CMS]),\n",
       " Equity(103 [CNC]),\n",
       " Equity(104 [CNP]),\n",
       " Equity(105 [COF]),\n",
       " Equity(106 [COG]),\n",
       " Equity(107 [COL]),\n",
       " Equity(108 [COO]),\n",
       " Equity(109 [COP]),\n",
       " Equity(110 [COST]),\n",
       " Equity(111 [COTY]),\n",
       " Equity(112 [CPB]),\n",
       " Equity(113 [CRM]),\n",
       " Equity(114 [CSCO]),\n",
       " Equity(115 [CSRA]),\n",
       " Equity(116 [CSX]),\n",
       " Equity(117 [CTAS]),\n",
       " Equity(118 [CTL]),\n",
       " Equity(119 [CTSH]),\n",
       " Equity(120 [CTXS]),\n",
       " Equity(121 [CVS]),\n",
       " Equity(122 [CVX]),\n",
       " Equity(123 [CXO]),\n",
       " Equity(124 [D]),\n",
       " Equity(125 [DAL]),\n",
       " Equity(126 [DE]),\n",
       " Equity(127 [DFS]),\n",
       " Equity(128 [DG]),\n",
       " Equity(129 [DGX]),\n",
       " Equity(130 [DHI]),\n",
       " Equity(131 [DHR]),\n",
       " Equity(132 [DIS]),\n",
       " Equity(133 [DISCA]),\n",
       " Equity(134 [DISCK]),\n",
       " Equity(135 [DISH]),\n",
       " Equity(136 [DLR]),\n",
       " Equity(137 [DLTR]),\n",
       " Equity(138 [DOV]),\n",
       " Equity(139 [DPS]),\n",
       " Equity(140 [DRE]),\n",
       " Equity(141 [DRI]),\n",
       " Equity(142 [DTE]),\n",
       " Equity(143 [DUK]),\n",
       " Equity(144 [DVA]),\n",
       " Equity(145 [DVN]),\n",
       " Equity(146 [EA]),\n",
       " Equity(147 [EBAY]),\n",
       " Equity(148 [ECL]),\n",
       " Equity(149 [ED]),\n",
       " Equity(150 [EFX]),\n",
       " Equity(151 [EIX]),\n",
       " Equity(152 [EL]),\n",
       " Equity(153 [EMN]),\n",
       " Equity(154 [EMR]),\n",
       " Equity(155 [EOG]),\n",
       " Equity(156 [EQIX]),\n",
       " Equity(157 [EQR]),\n",
       " Equity(158 [EQT]),\n",
       " Equity(159 [ES]),\n",
       " Equity(160 [ESRX]),\n",
       " Equity(161 [ESS]),\n",
       " Equity(162 [ETFC]),\n",
       " Equity(163 [ETN]),\n",
       " Equity(164 [ETR]),\n",
       " Equity(165 [EVHC]),\n",
       " Equity(166 [EW]),\n",
       " Equity(167 [EXC]),\n",
       " Equity(168 [EXPD]),\n",
       " Equity(169 [EXPE]),\n",
       " Equity(170 [EXR]),\n",
       " Equity(171 [F]),\n",
       " Equity(172 [FAST]),\n",
       " Equity(173 [FB]),\n",
       " Equity(174 [FBHS]),\n",
       " Equity(175 [FCX]),\n",
       " Equity(176 [FDX]),\n",
       " Equity(177 [FE]),\n",
       " Equity(178 [FFIV]),\n",
       " Equity(179 [FIS]),\n",
       " Equity(180 [FISV]),\n",
       " Equity(181 [FITB]),\n",
       " Equity(182 [FL]),\n",
       " Equity(183 [FLIR]),\n",
       " Equity(184 [FLR]),\n",
       " Equity(185 [FLS]),\n",
       " Equity(186 [FMC]),\n",
       " Equity(187 [FOX]),\n",
       " Equity(188 [FOXA]),\n",
       " Equity(189 [FRT]),\n",
       " Equity(190 [FTI]),\n",
       " Equity(191 [GD]),\n",
       " Equity(192 [GE]),\n",
       " Equity(193 [GGP]),\n",
       " Equity(194 [GILD]),\n",
       " Equity(195 [GIS]),\n",
       " Equity(196 [GLW]),\n",
       " Equity(197 [GM]),\n",
       " Equity(198 [GOOG]),\n",
       " Equity(199 [GOOGL]),\n",
       " Equity(200 [GPC]),\n",
       " Equity(201 [GPN]),\n",
       " Equity(202 [GPS]),\n",
       " Equity(203 [GRMN]),\n",
       " Equity(204 [GS]),\n",
       " Equity(205 [GT]),\n",
       " Equity(206 [GWW]),\n",
       " Equity(207 [HAL]),\n",
       " Equity(208 [HAS]),\n",
       " Equity(209 [HBAN]),\n",
       " Equity(210 [HBI]),\n",
       " Equity(211 [HCA]),\n",
       " Equity(212 [HCN]),\n",
       " Equity(213 [HCP]),\n",
       " Equity(214 [HD]),\n",
       " Equity(215 [HES]),\n",
       " Equity(216 [HIG]),\n",
       " Equity(217 [HLT]),\n",
       " Equity(218 [HOG]),\n",
       " Equity(219 [HOLX]),\n",
       " Equity(220 [HON]),\n",
       " Equity(221 [HP]),\n",
       " Equity(222 [HPE]),\n",
       " Equity(223 [HPQ]),\n",
       " Equity(224 [HRB]),\n",
       " Equity(225 [HRL]),\n",
       " Equity(226 [HRS]),\n",
       " Equity(227 [HSIC]),\n",
       " Equity(228 [HST]),\n",
       " Equity(229 [HSY]),\n",
       " Equity(230 [HUM]),\n",
       " Equity(231 [IBM]),\n",
       " Equity(232 [ICE]),\n",
       " Equity(233 [IDXX]),\n",
       " Equity(234 [IFF]),\n",
       " Equity(235 [ILMN]),\n",
       " Equity(236 [INCY]),\n",
       " Equity(237 [INFO]),\n",
       " Equity(238 [INTC]),\n",
       " Equity(239 [INTU]),\n",
       " Equity(240 [IP]),\n",
       " Equity(241 [IPG]),\n",
       " Equity(242 [IR]),\n",
       " Equity(243 [IRM]),\n",
       " Equity(244 [ISRG]),\n",
       " Equity(245 [IT]),\n",
       " Equity(246 [ITW]),\n",
       " Equity(247 [IVZ]),\n",
       " Equity(248 [JBHT]),\n",
       " Equity(249 [JCI]),\n",
       " Equity(250 [JEC]),\n",
       " Equity(251 [JNJ]),\n",
       " Equity(252 [JNPR]),\n",
       " Equity(253 [JPM]),\n",
       " Equity(254 [JWN]),\n",
       " Equity(255 [K]),\n",
       " Equity(256 [KEY]),\n",
       " Equity(257 [KHC]),\n",
       " Equity(258 [KIM]),\n",
       " Equity(259 [KLAC]),\n",
       " Equity(260 [KMB]),\n",
       " Equity(261 [KMI]),\n",
       " Equity(262 [KMX]),\n",
       " Equity(263 [KO]),\n",
       " Equity(264 [KORS]),\n",
       " Equity(265 [KR]),\n",
       " Equity(266 [KSS]),\n",
       " Equity(267 [KSU]),\n",
       " Equity(268 [L]),\n",
       " Equity(269 [LB]),\n",
       " Equity(270 [LEG]),\n",
       " Equity(271 [LEN]),\n",
       " Equity(272 [LH]),\n",
       " Equity(273 [LKQ]),\n",
       " Equity(274 [LLL]),\n",
       " Equity(275 [LLY]),\n",
       " Equity(276 [LMT]),\n",
       " Equity(277 [LNC]),\n",
       " Equity(278 [LNT]),\n",
       " Equity(279 [LOW]),\n",
       " Equity(280 [LRCX]),\n",
       " Equity(281 [LUK]),\n",
       " Equity(282 [LUV]),\n",
       " Equity(283 [LVLT]),\n",
       " Equity(284 [LYB]),\n",
       " Equity(285 [M]),\n",
       " Equity(286 [MA]),\n",
       " Equity(287 [MAA]),\n",
       " Equity(288 [MAC]),\n",
       " Equity(289 [MAR]),\n",
       " Equity(290 [MAS]),\n",
       " Equity(291 [MAT]),\n",
       " Equity(292 [MCD]),\n",
       " Equity(293 [MCHP]),\n",
       " Equity(294 [MCK]),\n",
       " Equity(295 [MCO]),\n",
       " Equity(296 [MDLZ]),\n",
       " Equity(297 [MDT]),\n",
       " Equity(298 [MET]),\n",
       " Equity(299 [MGM]),\n",
       " Equity(300 [MHK]),\n",
       " Equity(301 [MKC]),\n",
       " Equity(302 [MLM]),\n",
       " Equity(303 [MMC]),\n",
       " Equity(304 [MNST]),\n",
       " Equity(305 [MO]),\n",
       " Equity(306 [MON]),\n",
       " Equity(307 [MOS]),\n",
       " Equity(308 [MPC]),\n",
       " Equity(309 [MRK]),\n",
       " Equity(310 [MRO]),\n",
       " Equity(311 [MS]),\n",
       " Equity(312 [MSFT]),\n",
       " Equity(313 [MSI]),\n",
       " Equity(314 [MTB]),\n",
       " Equity(315 [MTD]),\n",
       " Equity(316 [MU]),\n",
       " Equity(317 [MYL]),\n",
       " Equity(318 [NAVI]),\n",
       " Equity(319 [NBL]),\n",
       " Equity(320 [NDAQ]),\n",
       " Equity(321 [NEE]),\n",
       " Equity(322 [NEM]),\n",
       " Equity(323 [NFLX]),\n",
       " Equity(324 [NFX]),\n",
       " Equity(325 [NI]),\n",
       " Equity(326 [NKE]),\n",
       " Equity(327 [NLSN]),\n",
       " Equity(328 [NOC]),\n",
       " Equity(329 [NOV]),\n",
       " Equity(330 [NRG]),\n",
       " Equity(331 [NSC]),\n",
       " Equity(332 [NTAP]),\n",
       " Equity(333 [NTRS]),\n",
       " Equity(334 [NUE]),\n",
       " Equity(335 [NVDA]),\n",
       " Equity(336 [NWL]),\n",
       " Equity(337 [NWS]),\n",
       " Equity(338 [NWSA]),\n",
       " Equity(339 [O]),\n",
       " Equity(340 [OKE]),\n",
       " Equity(341 [OMC]),\n",
       " Equity(342 [ORCL]),\n",
       " Equity(343 [ORLY]),\n",
       " Equity(344 [OXY]),\n",
       " Equity(345 [PAYX]),\n",
       " Equity(346 [PBCT]),\n",
       " Equity(347 [PCAR]),\n",
       " Equity(348 [PCG]),\n",
       " Equity(349 [PDCO]),\n",
       " Equity(350 [PEG]),\n",
       " Equity(351 [PEP]),\n",
       " Equity(352 [PFE]),\n",
       " Equity(353 [PFG]),\n",
       " Equity(354 [PG]),\n",
       " Equity(355 [PGR]),\n",
       " Equity(356 [PH]),\n",
       " Equity(357 [PHM]),\n",
       " Equity(358 [PKG]),\n",
       " Equity(359 [PKI]),\n",
       " Equity(360 [PLD]),\n",
       " Equity(361 [PM]),\n",
       " Equity(362 [PNC]),\n",
       " Equity(363 [PNR]),\n",
       " Equity(364 [PNW]),\n",
       " Equity(365 [PPG]),\n",
       " Equity(366 [PPL]),\n",
       " Equity(367 [PRGO]),\n",
       " Equity(368 [PRU]),\n",
       " Equity(369 [PSA]),\n",
       " Equity(370 [PSX]),\n",
       " Equity(371 [PVH]),\n",
       " Equity(372 [PWR]),\n",
       " Equity(373 [PX]),\n",
       " Equity(374 [PXD]),\n",
       " Equity(375 [PYPL]),\n",
       " Equity(376 [QCOM]),\n",
       " Equity(377 [QRVO]),\n",
       " Equity(378 [RCL]),\n",
       " Equity(379 [RE]),\n",
       " Equity(380 [REG]),\n",
       " Equity(381 [REGN]),\n",
       " Equity(382 [RF]),\n",
       " Equity(383 [RHI]),\n",
       " Equity(384 [RHT]),\n",
       " Equity(385 [RJF]),\n",
       " Equity(386 [RL]),\n",
       " Equity(387 [RMD]),\n",
       " Equity(388 [ROK]),\n",
       " Equity(389 [ROP]),\n",
       " Equity(390 [ROST]),\n",
       " Equity(391 [RRC]),\n",
       " Equity(392 [RSG]),\n",
       " Equity(393 [RTN]),\n",
       " Equity(394 [SBAC]),\n",
       " Equity(395 [SBUX]),\n",
       " Equity(396 [SCG]),\n",
       " Equity(397 [SCHW]),\n",
       " Equity(398 [SEE]),\n",
       " Equity(399 [SHW]),\n",
       " Equity(400 [SIG]),\n",
       " Equity(401 [SJM]),\n",
       " Equity(402 [SLB]),\n",
       " Equity(403 [SLG]),\n",
       " Equity(404 [SNA]),\n",
       " Equity(405 [SNI]),\n",
       " Equity(406 [SNPS]),\n",
       " Equity(407 [SO]),\n",
       " Equity(408 [SPG]),\n",
       " Equity(409 [SPLS]),\n",
       " Equity(410 [SRCL]),\n",
       " Equity(411 [SRE]),\n",
       " Equity(412 [STI]),\n",
       " Equity(413 [STT]),\n",
       " Equity(414 [STX]),\n",
       " Equity(415 [STZ]),\n",
       " Equity(416 [SWK]),\n",
       " Equity(417 [SWKS]),\n",
       " Equity(418 [SYF]),\n",
       " Equity(419 [SYK]),\n",
       " Equity(420 [SYMC]),\n",
       " Equity(421 [SYY]),\n",
       " Equity(422 [T]),\n",
       " Equity(423 [TAP]),\n",
       " Equity(424 [TDG]),\n",
       " Equity(425 [TEL]),\n",
       " Equity(426 [TGT]),\n",
       " Equity(427 [TIF]),\n",
       " Equity(428 [TJX]),\n",
       " Equity(429 [TMK]),\n",
       " Equity(430 [TMO]),\n",
       " Equity(431 [TRIP]),\n",
       " Equity(432 [TROW]),\n",
       " Equity(433 [TRV]),\n",
       " Equity(434 [TSCO]),\n",
       " Equity(435 [TSN]),\n",
       " Equity(436 [TSS]),\n",
       " Equity(437 [TWX]),\n",
       " Equity(438 [TXN]),\n",
       " Equity(439 [TXT]),\n",
       " Equity(440 [UAA]),\n",
       " Equity(441 [UAL]),\n",
       " Equity(442 [UDR]),\n",
       " Equity(443 [UHS]),\n",
       " Equity(444 [ULTA]),\n",
       " Equity(445 [UNH]),\n",
       " Equity(446 [UNM]),\n",
       " Equity(447 [UNP]),\n",
       " Equity(448 [UPS]),\n",
       " Equity(449 [URI]),\n",
       " Equity(450 [USB]),\n",
       " Equity(451 [UTX]),\n",
       " Equity(452 [V]),\n",
       " Equity(453 [VAR]),\n",
       " Equity(454 [VFC]),\n",
       " Equity(455 [VIAB]),\n",
       " Equity(456 [VLO]),\n",
       " Equity(457 [VMC]),\n",
       " Equity(458 [VNO]),\n",
       " Equity(459 [VRSK]),\n",
       " Equity(460 [VRSN]),\n",
       " Equity(461 [VRTX]),\n",
       " Equity(462 [VTR]),\n",
       " Equity(463 [VZ]),\n",
       " Equity(464 [WAT]),\n",
       " Equity(465 [WBA]),\n",
       " Equity(466 [WDC]),\n",
       " Equity(467 [WEC]),\n",
       " Equity(468 [WFC]),\n",
       " Equity(469 [WHR]),\n",
       " Equity(471 [WM]),\n",
       " Equity(472 [WMB]),\n",
       " Equity(473 [WMT]),\n",
       " Equity(474 [WRK]),\n",
       " Equity(475 [WU]),\n",
       " Equity(476 [WY]),\n",
       " Equity(477 [WYN]),\n",
       " Equity(478 [WYNN]),\n",
       " Equity(479 [XEC]),\n",
       " Equity(480 [XEL]),\n",
       " Equity(481 [XL]),\n",
       " Equity(482 [XLNX]),\n",
       " Equity(483 [XOM]),\n",
       " Equity(484 [XRAY]),\n",
       " Equity(485 [XRX]),\n",
       " Equity(486 [XYL]),\n",
       " Equity(487 [YUM]),\n",
       " Equity(488 [ZBH]),\n",
       " Equity(489 [ZION]),\n",
       " Equity(490 [ZTS])]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "universe_end_date = pd.Timestamp('2016-01-05', tz='UTC')\n",
    "\n",
    "universe_tickers = engine\\\n",
    "    .run_pipeline(\n",
    "        Pipeline(screen=universe),\n",
    "        universe_end_date,\n",
    "        universe_end_date)\\\n",
    "    .index.get_level_values(1)\\\n",
    "    .values.tolist()\n",
    "    \n",
    "universe_tickers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "490"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(universe_tickers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "from zipline.data.data_portal import DataPortal\n",
    "\n",
    "data_portal = DataPortal(\n",
    "    bundle_data.asset_finder,\n",
    "    trading_calendar=trading_calendar,\n",
    "    first_trading_day=bundle_data.equity_daily_bar_reader.first_trading_day,\n",
    "    equity_minute_reader=None,\n",
    "    equity_daily_reader=bundle_data.equity_daily_bar_reader,\n",
    "    adjustment_reader=bundle_data.adjustment_reader)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get pricing data helper function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "from quiz_helper import get_pricing"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## get pricing data into a dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Equity(0 [A])</th>\n",
       "      <th>Equity(1 [AAL])</th>\n",
       "      <th>Equity(2 [AAP])</th>\n",
       "      <th>Equity(3 [AAPL])</th>\n",
       "      <th>Equity(4 [ABBV])</th>\n",
       "      <th>Equity(5 [ABC])</th>\n",
       "      <th>Equity(6 [ABT])</th>\n",
       "      <th>Equity(7 [ACN])</th>\n",
       "      <th>Equity(8 [ADBE])</th>\n",
       "      <th>Equity(9 [ADI])</th>\n",
       "      <th>...</th>\n",
       "      <th>Equity(481 [XL])</th>\n",
       "      <th>Equity(482 [XLNX])</th>\n",
       "      <th>Equity(483 [XOM])</th>\n",
       "      <th>Equity(484 [XRAY])</th>\n",
       "      <th>Equity(485 [XRX])</th>\n",
       "      <th>Equity(486 [XYL])</th>\n",
       "      <th>Equity(487 [YUM])</th>\n",
       "      <th>Equity(488 [ZBH])</th>\n",
       "      <th>Equity(489 [ZION])</th>\n",
       "      <th>Equity(490 [ZTS])</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2011-01-07 00:00:00+00:00</th>\n",
       "      <td>0.008437</td>\n",
       "      <td>0.014230</td>\n",
       "      <td>0.026702</td>\n",
       "      <td>0.007146</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001994</td>\n",
       "      <td>0.004165</td>\n",
       "      <td>0.001648</td>\n",
       "      <td>-0.007127</td>\n",
       "      <td>-0.005818</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.001838</td>\n",
       "      <td>-0.005619</td>\n",
       "      <td>0.005461</td>\n",
       "      <td>-0.004044</td>\n",
       "      <td>-0.013953</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.012457</td>\n",
       "      <td>-0.000181</td>\n",
       "      <td>-0.010458</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-10 00:00:00+00:00</th>\n",
       "      <td>-0.004174</td>\n",
       "      <td>0.006195</td>\n",
       "      <td>0.007435</td>\n",
       "      <td>0.018852</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.005714</td>\n",
       "      <td>-0.008896</td>\n",
       "      <td>-0.008854</td>\n",
       "      <td>0.028714</td>\n",
       "      <td>0.002926</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000947</td>\n",
       "      <td>0.007814</td>\n",
       "      <td>-0.006081</td>\n",
       "      <td>0.010466</td>\n",
       "      <td>0.009733</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001440</td>\n",
       "      <td>0.007784</td>\n",
       "      <td>-0.017945</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-11 00:00:00+00:00</th>\n",
       "      <td>-0.001886</td>\n",
       "      <td>-0.043644</td>\n",
       "      <td>-0.005927</td>\n",
       "      <td>-0.002367</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.009783</td>\n",
       "      <td>-0.002067</td>\n",
       "      <td>0.013717</td>\n",
       "      <td>0.000607</td>\n",
       "      <td>0.008753</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001314</td>\n",
       "      <td>0.010179</td>\n",
       "      <td>0.007442</td>\n",
       "      <td>0.007351</td>\n",
       "      <td>0.006116</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.006470</td>\n",
       "      <td>0.035676</td>\n",
       "      <td>0.007467</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-12 00:00:00+00:00</th>\n",
       "      <td>0.017254</td>\n",
       "      <td>-0.008237</td>\n",
       "      <td>0.013387</td>\n",
       "      <td>0.008133</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.005979</td>\n",
       "      <td>-0.001011</td>\n",
       "      <td>0.022969</td>\n",
       "      <td>0.017950</td>\n",
       "      <td>0.000257</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004986</td>\n",
       "      <td>0.015666</td>\n",
       "      <td>0.011763</td>\n",
       "      <td>0.027182</td>\n",
       "      <td>0.004386</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002631</td>\n",
       "      <td>0.014741</td>\n",
       "      <td>-0.011903</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-13 00:00:00+00:00</th>\n",
       "      <td>-0.004559</td>\n",
       "      <td>0.000955</td>\n",
       "      <td>0.003031</td>\n",
       "      <td>0.003657</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.014925</td>\n",
       "      <td>-0.004451</td>\n",
       "      <td>-0.000400</td>\n",
       "      <td>-0.005719</td>\n",
       "      <td>-0.005012</td>\n",
       "      <td>...</td>\n",
       "      <td>0.030499</td>\n",
       "      <td>-0.003217</td>\n",
       "      <td>0.001694</td>\n",
       "      <td>0.000547</td>\n",
       "      <td>-0.018235</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.005084</td>\n",
       "      <td>-0.004665</td>\n",
       "      <td>-0.009178</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-14 00:00:00+00:00</th>\n",
       "      <td>0.003439</td>\n",
       "      <td>-0.009156</td>\n",
       "      <td>0.003022</td>\n",
       "      <td>0.008106</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001395</td>\n",
       "      <td>-0.010111</td>\n",
       "      <td>0.002590</td>\n",
       "      <td>0.012283</td>\n",
       "      <td>0.019827</td>\n",
       "      <td>...</td>\n",
       "      <td>0.026607</td>\n",
       "      <td>0.025894</td>\n",
       "      <td>0.014743</td>\n",
       "      <td>-0.000287</td>\n",
       "      <td>0.026494</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.021661</td>\n",
       "      <td>0.005949</td>\n",
       "      <td>0.033177</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-18 00:00:00+00:00</th>\n",
       "      <td>0.034254</td>\n",
       "      <td>-0.062085</td>\n",
       "      <td>-0.004286</td>\n",
       "      <td>-0.022474</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.020889</td>\n",
       "      <td>0.006621</td>\n",
       "      <td>0.006998</td>\n",
       "      <td>0.011542</td>\n",
       "      <td>0.032645</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001678</td>\n",
       "      <td>0.002501</td>\n",
       "      <td>0.011163</td>\n",
       "      <td>0.011589</td>\n",
       "      <td>0.006044</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.029453</td>\n",
       "      <td>0.006998</td>\n",
       "      <td>-0.008534</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-19 00:00:00+00:00</th>\n",
       "      <td>-0.010224</td>\n",
       "      <td>-0.008929</td>\n",
       "      <td>0.008754</td>\n",
       "      <td>-0.005314</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.017144</td>\n",
       "      <td>0.002753</td>\n",
       "      <td>-0.002962</td>\n",
       "      <td>-0.007899</td>\n",
       "      <td>-0.020575</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.014834</td>\n",
       "      <td>-0.023590</td>\n",
       "      <td>-0.005968</td>\n",
       "      <td>-0.019899</td>\n",
       "      <td>-0.012847</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000818</td>\n",
       "      <td>-0.004098</td>\n",
       "      <td>-0.018433</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-20 00:00:00+00:00</th>\n",
       "      <td>-0.008496</td>\n",
       "      <td>0.021953</td>\n",
       "      <td>-0.004732</td>\n",
       "      <td>-0.018189</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.004794</td>\n",
       "      <td>0.013322</td>\n",
       "      <td>0.018713</td>\n",
       "      <td>-0.012386</td>\n",
       "      <td>-0.002818</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.024512</td>\n",
       "      <td>0.007744</td>\n",
       "      <td>-0.006261</td>\n",
       "      <td>-0.000841</td>\n",
       "      <td>-0.033798</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.013182</td>\n",
       "      <td>-0.001612</td>\n",
       "      <td>-0.007972</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-21 00:00:00+00:00</th>\n",
       "      <td>0.007873</td>\n",
       "      <td>-0.041038</td>\n",
       "      <td>0.005544</td>\n",
       "      <td>-0.017911</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010642</td>\n",
       "      <td>-0.000853</td>\n",
       "      <td>-0.001952</td>\n",
       "      <td>-0.006569</td>\n",
       "      <td>-0.004113</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000615</td>\n",
       "      <td>0.015825</td>\n",
       "      <td>-0.003048</td>\n",
       "      <td>-0.000872</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.007590</td>\n",
       "      <td>0.009325</td>\n",
       "      <td>0.024020</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-24 00:00:00+00:00</th>\n",
       "      <td>0.014646</td>\n",
       "      <td>0.027473</td>\n",
       "      <td>-0.001106</td>\n",
       "      <td>0.032837</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.005249</td>\n",
       "      <td>0.005223</td>\n",
       "      <td>0.008420</td>\n",
       "      <td>0.022843</td>\n",
       "      <td>0.014974</td>\n",
       "      <td>...</td>\n",
       "      <td>0.012359</td>\n",
       "      <td>0.016011</td>\n",
       "      <td>-0.004943</td>\n",
       "      <td>0.001660</td>\n",
       "      <td>0.008049</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000601</td>\n",
       "      <td>-0.016501</td>\n",
       "      <td>-0.023021</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-25 00:00:00+00:00</th>\n",
       "      <td>-0.006736</td>\n",
       "      <td>0.002982</td>\n",
       "      <td>0.009146</td>\n",
       "      <td>0.011710</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.009363</td>\n",
       "      <td>-0.004347</td>\n",
       "      <td>0.004859</td>\n",
       "      <td>-0.013811</td>\n",
       "      <td>-0.014505</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002178</td>\n",
       "      <td>0.006273</td>\n",
       "      <td>0.001154</td>\n",
       "      <td>0.001134</td>\n",
       "      <td>0.015143</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.006208</td>\n",
       "      <td>0.017142</td>\n",
       "      <td>-0.008836</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-26 00:00:00+00:00</th>\n",
       "      <td>-0.030736</td>\n",
       "      <td>0.066133</td>\n",
       "      <td>0.003593</td>\n",
       "      <td>0.007193</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.012227</td>\n",
       "      <td>-0.025241</td>\n",
       "      <td>0.012192</td>\n",
       "      <td>-0.001192</td>\n",
       "      <td>0.002837</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002628</td>\n",
       "      <td>0.005934</td>\n",
       "      <td>0.012453</td>\n",
       "      <td>0.000552</td>\n",
       "      <td>-0.076291</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.004803</td>\n",
       "      <td>-0.019524</td>\n",
       "      <td>-0.010626</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-27 00:00:00+00:00</th>\n",
       "      <td>0.007721</td>\n",
       "      <td>0.023178</td>\n",
       "      <td>-0.001553</td>\n",
       "      <td>-0.001877</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.011833</td>\n",
       "      <td>-0.007928</td>\n",
       "      <td>0.000179</td>\n",
       "      <td>0.009845</td>\n",
       "      <td>0.007480</td>\n",
       "      <td>...</td>\n",
       "      <td>0.014267</td>\n",
       "      <td>0.021169</td>\n",
       "      <td>0.002751</td>\n",
       "      <td>0.016396</td>\n",
       "      <td>0.024664</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.003746</td>\n",
       "      <td>0.068754</td>\n",
       "      <td>0.020160</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-28 00:00:00+00:00</th>\n",
       "      <td>-0.018846</td>\n",
       "      <td>-0.080553</td>\n",
       "      <td>-0.000936</td>\n",
       "      <td>-0.020710</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.022262</td>\n",
       "      <td>-0.019200</td>\n",
       "      <td>-0.016035</td>\n",
       "      <td>-0.040177</td>\n",
       "      <td>-0.022460</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.025647</td>\n",
       "      <td>-0.020108</td>\n",
       "      <td>-0.011131</td>\n",
       "      <td>-0.021871</td>\n",
       "      <td>-0.022229</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.025001</td>\n",
       "      <td>-0.008472</td>\n",
       "      <td>-0.013873</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-31 00:00:00+00:00</th>\n",
       "      <td>0.003608</td>\n",
       "      <td>-0.023615</td>\n",
       "      <td>-0.002351</td>\n",
       "      <td>0.009578</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.003893</td>\n",
       "      <td>-0.007248</td>\n",
       "      <td>-0.000980</td>\n",
       "      <td>0.017236</td>\n",
       "      <td>0.013818</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004846</td>\n",
       "      <td>0.000298</td>\n",
       "      <td>0.021396</td>\n",
       "      <td>-0.007560</td>\n",
       "      <td>0.006615</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.007748</td>\n",
       "      <td>0.009902</td>\n",
       "      <td>0.006378</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-01 00:00:00+00:00</th>\n",
       "      <td>0.011654</td>\n",
       "      <td>-0.001047</td>\n",
       "      <td>-0.009218</td>\n",
       "      <td>0.016818</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.011976</td>\n",
       "      <td>0.001546</td>\n",
       "      <td>0.017498</td>\n",
       "      <td>0.013918</td>\n",
       "      <td>0.021624</td>\n",
       "      <td>...</td>\n",
       "      <td>0.015687</td>\n",
       "      <td>0.032003</td>\n",
       "      <td>0.040037</td>\n",
       "      <td>0.024795</td>\n",
       "      <td>0.024498</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.014102</td>\n",
       "      <td>0.017746</td>\n",
       "      <td>0.030970</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-02 00:00:00+00:00</th>\n",
       "      <td>0.010112</td>\n",
       "      <td>-0.039304</td>\n",
       "      <td>-0.027477</td>\n",
       "      <td>-0.002053</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.021197</td>\n",
       "      <td>0.011068</td>\n",
       "      <td>0.003632</td>\n",
       "      <td>-0.002387</td>\n",
       "      <td>0.002280</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.012846</td>\n",
       "      <td>-0.004518</td>\n",
       "      <td>-0.005958</td>\n",
       "      <td>-0.010390</td>\n",
       "      <td>-0.001827</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.006562</td>\n",
       "      <td>0.005161</td>\n",
       "      <td>-0.003706</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-03 00:00:00+00:00</th>\n",
       "      <td>-0.000289</td>\n",
       "      <td>0.007310</td>\n",
       "      <td>0.014126</td>\n",
       "      <td>-0.002560</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.003662</td>\n",
       "      <td>0.005894</td>\n",
       "      <td>0.004178</td>\n",
       "      <td>0.002991</td>\n",
       "      <td>-0.013341</td>\n",
       "      <td>...</td>\n",
       "      <td>0.010430</td>\n",
       "      <td>-0.008169</td>\n",
       "      <td>0.000347</td>\n",
       "      <td>0.008556</td>\n",
       "      <td>0.004596</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.031413</td>\n",
       "      <td>-0.000333</td>\n",
       "      <td>-0.000394</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-04 00:00:00+00:00</th>\n",
       "      <td>0.005627</td>\n",
       "      <td>-0.036500</td>\n",
       "      <td>0.024014</td>\n",
       "      <td>0.008915</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.033047</td>\n",
       "      <td>0.002616</td>\n",
       "      <td>-0.004360</td>\n",
       "      <td>-0.005070</td>\n",
       "      <td>0.019659</td>\n",
       "      <td>...</td>\n",
       "      <td>0.009471</td>\n",
       "      <td>0.024709</td>\n",
       "      <td>-0.001917</td>\n",
       "      <td>0.003048</td>\n",
       "      <td>-0.005506</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001408</td>\n",
       "      <td>0.002471</td>\n",
       "      <td>0.016111</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-07 00:00:00+00:00</th>\n",
       "      <td>0.007709</td>\n",
       "      <td>0.052046</td>\n",
       "      <td>0.008114</td>\n",
       "      <td>0.015538</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.002178</td>\n",
       "      <td>-0.009341</td>\n",
       "      <td>0.002279</td>\n",
       "      <td>0.005995</td>\n",
       "      <td>-0.003514</td>\n",
       "      <td>...</td>\n",
       "      <td>0.006801</td>\n",
       "      <td>-0.005073</td>\n",
       "      <td>0.007803</td>\n",
       "      <td>0.006852</td>\n",
       "      <td>0.002768</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002028</td>\n",
       "      <td>-0.010876</td>\n",
       "      <td>0.027617</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-08 00:00:00+00:00</th>\n",
       "      <td>0.010854</td>\n",
       "      <td>0.016455</td>\n",
       "      <td>0.006202</td>\n",
       "      <td>0.009440</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002182</td>\n",
       "      <td>-0.001738</td>\n",
       "      <td>-0.000557</td>\n",
       "      <td>0.000298</td>\n",
       "      <td>-0.006010</td>\n",
       "      <td>...</td>\n",
       "      <td>0.003846</td>\n",
       "      <td>0.001795</td>\n",
       "      <td>-0.006077</td>\n",
       "      <td>0.005182</td>\n",
       "      <td>-0.002761</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.003851</td>\n",
       "      <td>-0.000495</td>\n",
       "      <td>0.004780</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-09 00:00:00+00:00</th>\n",
       "      <td>0.004664</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.016955</td>\n",
       "      <td>0.008332</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.003006</td>\n",
       "      <td>-0.001530</td>\n",
       "      <td>0.001138</td>\n",
       "      <td>-0.016682</td>\n",
       "      <td>0.004781</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.011837</td>\n",
       "      <td>-0.001792</td>\n",
       "      <td>-0.005178</td>\n",
       "      <td>-0.018441</td>\n",
       "      <td>0.003705</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.001821</td>\n",
       "      <td>-0.009851</td>\n",
       "      <td>-0.004757</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-10 00:00:00+00:00</th>\n",
       "      <td>0.000413</td>\n",
       "      <td>-0.003048</td>\n",
       "      <td>-0.011367</td>\n",
       "      <td>-0.010109</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001101</td>\n",
       "      <td>-0.001110</td>\n",
       "      <td>0.005503</td>\n",
       "      <td>0.016965</td>\n",
       "      <td>0.004513</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.008947</td>\n",
       "      <td>0.003914</td>\n",
       "      <td>0.007876</td>\n",
       "      <td>0.005512</td>\n",
       "      <td>-0.004624</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.004853</td>\n",
       "      <td>0.011449</td>\n",
       "      <td>-0.026498</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-11 00:00:00+00:00</th>\n",
       "      <td>-0.007150</td>\n",
       "      <td>0.028364</td>\n",
       "      <td>0.000764</td>\n",
       "      <td>0.006505</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.001375</td>\n",
       "      <td>0.001534</td>\n",
       "      <td>-0.011146</td>\n",
       "      <td>0.002979</td>\n",
       "      <td>0.015007</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001705</td>\n",
       "      <td>0.010765</td>\n",
       "      <td>-0.004562</td>\n",
       "      <td>0.007147</td>\n",
       "      <td>0.012021</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000616</td>\n",
       "      <td>0.009660</td>\n",
       "      <td>0.014256</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-14 00:00:00+00:00</th>\n",
       "      <td>0.001663</td>\n",
       "      <td>-0.015790</td>\n",
       "      <td>-0.023274</td>\n",
       "      <td>0.006529</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.005750</td>\n",
       "      <td>0.009245</td>\n",
       "      <td>0.000202</td>\n",
       "      <td>0.005643</td>\n",
       "      <td>0.009877</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.011616</td>\n",
       "      <td>0.000318</td>\n",
       "      <td>0.025230</td>\n",
       "      <td>-0.005443</td>\n",
       "      <td>0.005476</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010657</td>\n",
       "      <td>0.002484</td>\n",
       "      <td>-0.010021</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-15 00:00:00+00:00</th>\n",
       "      <td>-0.011905</td>\n",
       "      <td>0.011043</td>\n",
       "      <td>-0.003926</td>\n",
       "      <td>0.002016</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.007329</td>\n",
       "      <td>0.016750</td>\n",
       "      <td>-0.008021</td>\n",
       "      <td>0.002363</td>\n",
       "      <td>0.000239</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.006079</td>\n",
       "      <td>-0.001804</td>\n",
       "      <td>-0.022853</td>\n",
       "      <td>0.004097</td>\n",
       "      <td>0.003604</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.008526</td>\n",
       "      <td>-0.001815</td>\n",
       "      <td>-0.004461</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-16 00:00:00+00:00</th>\n",
       "      <td>0.015123</td>\n",
       "      <td>0.001958</td>\n",
       "      <td>0.013860</td>\n",
       "      <td>0.008967</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.003554</td>\n",
       "      <td>-0.010502</td>\n",
       "      <td>0.027329</td>\n",
       "      <td>0.022098</td>\n",
       "      <td>-0.003905</td>\n",
       "      <td>...</td>\n",
       "      <td>0.009174</td>\n",
       "      <td>0.003863</td>\n",
       "      <td>0.008682</td>\n",
       "      <td>0.000285</td>\n",
       "      <td>0.027093</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.008898</td>\n",
       "      <td>0.010557</td>\n",
       "      <td>0.001206</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-17 00:00:00+00:00</th>\n",
       "      <td>-0.003311</td>\n",
       "      <td>-0.017791</td>\n",
       "      <td>-0.024844</td>\n",
       "      <td>-0.013309</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.029148</td>\n",
       "      <td>0.001301</td>\n",
       "      <td>0.011784</td>\n",
       "      <td>0.008360</td>\n",
       "      <td>0.008559</td>\n",
       "      <td>...</td>\n",
       "      <td>0.015656</td>\n",
       "      <td>0.000318</td>\n",
       "      <td>0.002275</td>\n",
       "      <td>-0.001911</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.003906</td>\n",
       "      <td>0.015325</td>\n",
       "      <td>-0.003227</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-02-18 00:00:00+00:00</th>\n",
       "      <td>0.011078</td>\n",
       "      <td>-0.020103</td>\n",
       "      <td>-0.006693</td>\n",
       "      <td>-0.021595</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.009620</td>\n",
       "      <td>0.012106</td>\n",
       "      <td>-0.007953</td>\n",
       "      <td>0.011721</td>\n",
       "      <td>-0.001691</td>\n",
       "      <td>...</td>\n",
       "      <td>0.053404</td>\n",
       "      <td>0.001447</td>\n",
       "      <td>0.007393</td>\n",
       "      <td>0.013148</td>\n",
       "      <td>-0.004390</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.004110</td>\n",
       "      <td>0.023782</td>\n",
       "      <td>-0.017960</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-11-20 00:00:00+00:00</th>\n",
       "      <td>0.001072</td>\n",
       "      <td>-0.002373</td>\n",
       "      <td>0.002767</td>\n",
       "      <td>0.004381</td>\n",
       "      <td>0.009256</td>\n",
       "      <td>-0.000905</td>\n",
       "      <td>0.006113</td>\n",
       "      <td>0.006430</td>\n",
       "      <td>0.000545</td>\n",
       "      <td>-0.005843</td>\n",
       "      <td>...</td>\n",
       "      <td>0.008131</td>\n",
       "      <td>0.000412</td>\n",
       "      <td>-0.006352</td>\n",
       "      <td>0.002793</td>\n",
       "      <td>0.002899</td>\n",
       "      <td>-0.004498</td>\n",
       "      <td>0.015060</td>\n",
       "      <td>-0.003176</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.008950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-11-23 00:00:00+00:00</th>\n",
       "      <td>-0.007094</td>\n",
       "      <td>0.002379</td>\n",
       "      <td>-0.001228</td>\n",
       "      <td>-0.012989</td>\n",
       "      <td>0.000646</td>\n",
       "      <td>-0.003728</td>\n",
       "      <td>-0.012381</td>\n",
       "      <td>-0.001206</td>\n",
       "      <td>0.001634</td>\n",
       "      <td>-0.044107</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.004696</td>\n",
       "      <td>-0.006955</td>\n",
       "      <td>0.006131</td>\n",
       "      <td>0.007345</td>\n",
       "      <td>0.027692</td>\n",
       "      <td>0.001322</td>\n",
       "      <td>-0.000966</td>\n",
       "      <td>-0.008581</td>\n",
       "      <td>-0.001992</td>\n",
       "      <td>-0.007600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-11-24 00:00:00+00:00</th>\n",
       "      <td>0.002085</td>\n",
       "      <td>-0.025309</td>\n",
       "      <td>0.003504</td>\n",
       "      <td>0.009594</td>\n",
       "      <td>-0.000323</td>\n",
       "      <td>-0.002336</td>\n",
       "      <td>0.000210</td>\n",
       "      <td>-0.004537</td>\n",
       "      <td>0.000435</td>\n",
       "      <td>0.063741</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.000777</td>\n",
       "      <td>0.012960</td>\n",
       "      <td>0.019935</td>\n",
       "      <td>-0.009563</td>\n",
       "      <td>-0.012992</td>\n",
       "      <td>-0.001871</td>\n",
       "      <td>-0.004252</td>\n",
       "      <td>-0.009043</td>\n",
       "      <td>0.002650</td>\n",
       "      <td>-0.000651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-11-25 00:00:00+00:00</th>\n",
       "      <td>-0.008206</td>\n",
       "      <td>0.001938</td>\n",
       "      <td>0.006805</td>\n",
       "      <td>-0.007151</td>\n",
       "      <td>-0.013744</td>\n",
       "      <td>0.004365</td>\n",
       "      <td>-0.000862</td>\n",
       "      <td>-0.002338</td>\n",
       "      <td>-0.002500</td>\n",
       "      <td>-0.002810</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.008888</td>\n",
       "      <td>-0.004458</td>\n",
       "      <td>-0.007690</td>\n",
       "      <td>-0.002792</td>\n",
       "      <td>-0.001913</td>\n",
       "      <td>0.004824</td>\n",
       "      <td>0.002894</td>\n",
       "      <td>-0.006174</td>\n",
       "      <td>-0.000309</td>\n",
       "      <td>0.000868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-11-27 00:00:00+00:00</th>\n",
       "      <td>-0.003256</td>\n",
       "      <td>0.009201</td>\n",
       "      <td>0.003285</td>\n",
       "      <td>-0.001863</td>\n",
       "      <td>-0.004803</td>\n",
       "      <td>0.000612</td>\n",
       "      <td>0.000210</td>\n",
       "      <td>0.003363</td>\n",
       "      <td>0.004359</td>\n",
       "      <td>0.003315</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004736</td>\n",
       "      <td>0.004478</td>\n",
       "      <td>-0.000257</td>\n",
       "      <td>0.002633</td>\n",
       "      <td>0.003795</td>\n",
       "      <td>-0.002140</td>\n",
       "      <td>0.005105</td>\n",
       "      <td>-0.002869</td>\n",
       "      <td>0.005013</td>\n",
       "      <td>0.002343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-11-30 00:00:00+00:00</th>\n",
       "      <td>-0.010209</td>\n",
       "      <td>-0.010321</td>\n",
       "      <td>-0.012798</td>\n",
       "      <td>0.004159</td>\n",
       "      <td>-0.030838</td>\n",
       "      <td>-0.003542</td>\n",
       "      <td>-0.011004</td>\n",
       "      <td>-0.002228</td>\n",
       "      <td>-0.007703</td>\n",
       "      <td>0.019522</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004212</td>\n",
       "      <td>0.009348</td>\n",
       "      <td>0.005294</td>\n",
       "      <td>-0.007363</td>\n",
       "      <td>-0.007524</td>\n",
       "      <td>-0.006928</td>\n",
       "      <td>-0.006183</td>\n",
       "      <td>0.000101</td>\n",
       "      <td>-0.004339</td>\n",
       "      <td>-0.008071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-01 00:00:00+00:00</th>\n",
       "      <td>0.015748</td>\n",
       "      <td>0.048493</td>\n",
       "      <td>-0.002396</td>\n",
       "      <td>-0.008116</td>\n",
       "      <td>0.014957</td>\n",
       "      <td>0.008718</td>\n",
       "      <td>0.012022</td>\n",
       "      <td>0.008480</td>\n",
       "      <td>0.011918</td>\n",
       "      <td>-0.000970</td>\n",
       "      <td>...</td>\n",
       "      <td>0.015192</td>\n",
       "      <td>0.011075</td>\n",
       "      <td>0.002821</td>\n",
       "      <td>0.021600</td>\n",
       "      <td>0.013276</td>\n",
       "      <td>0.008582</td>\n",
       "      <td>0.027170</td>\n",
       "      <td>0.016927</td>\n",
       "      <td>0.015028</td>\n",
       "      <td>0.006632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-02 00:00:00+00:00</th>\n",
       "      <td>-0.005284</td>\n",
       "      <td>0.012930</td>\n",
       "      <td>-0.027166</td>\n",
       "      <td>-0.009030</td>\n",
       "      <td>-0.022022</td>\n",
       "      <td>-0.006534</td>\n",
       "      <td>-0.005287</td>\n",
       "      <td>-0.004991</td>\n",
       "      <td>-0.005727</td>\n",
       "      <td>-0.006990</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.003858</td>\n",
       "      <td>-0.024693</td>\n",
       "      <td>-0.028571</td>\n",
       "      <td>0.007572</td>\n",
       "      <td>-0.029962</td>\n",
       "      <td>-0.018335</td>\n",
       "      <td>0.006313</td>\n",
       "      <td>-0.004473</td>\n",
       "      <td>-0.015448</td>\n",
       "      <td>-0.013610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-03 00:00:00+00:00</th>\n",
       "      <td>-0.009521</td>\n",
       "      <td>-0.012555</td>\n",
       "      <td>-0.019944</td>\n",
       "      <td>-0.009292</td>\n",
       "      <td>-0.027724</td>\n",
       "      <td>-0.001415</td>\n",
       "      <td>-0.023650</td>\n",
       "      <td>-0.015429</td>\n",
       "      <td>-0.022930</td>\n",
       "      <td>-0.027826</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.008294</td>\n",
       "      <td>-0.010820</td>\n",
       "      <td>-0.014327</td>\n",
       "      <td>0.002733</td>\n",
       "      <td>-0.000959</td>\n",
       "      <td>-0.005676</td>\n",
       "      <td>-0.024272</td>\n",
       "      <td>-0.028367</td>\n",
       "      <td>-0.015725</td>\n",
       "      <td>-0.025244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-04 00:00:00+00:00</th>\n",
       "      <td>0.020199</td>\n",
       "      <td>0.039303</td>\n",
       "      <td>0.006779</td>\n",
       "      <td>0.033246</td>\n",
       "      <td>0.018899</td>\n",
       "      <td>0.011957</td>\n",
       "      <td>0.026046</td>\n",
       "      <td>0.029924</td>\n",
       "      <td>0.029696</td>\n",
       "      <td>0.002713</td>\n",
       "      <td>...</td>\n",
       "      <td>0.022211</td>\n",
       "      <td>0.010326</td>\n",
       "      <td>0.005736</td>\n",
       "      <td>0.007495</td>\n",
       "      <td>0.011599</td>\n",
       "      <td>0.024774</td>\n",
       "      <td>0.041159</td>\n",
       "      <td>0.011977</td>\n",
       "      <td>0.024452</td>\n",
       "      <td>0.027882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-07 00:00:00+00:00</th>\n",
       "      <td>-0.000340</td>\n",
       "      <td>0.018020</td>\n",
       "      <td>-0.029578</td>\n",
       "      <td>-0.006298</td>\n",
       "      <td>-0.015921</td>\n",
       "      <td>0.000898</td>\n",
       "      <td>0.005727</td>\n",
       "      <td>-0.001463</td>\n",
       "      <td>-0.032188</td>\n",
       "      <td>-0.011988</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.008791</td>\n",
       "      <td>-0.026122</td>\n",
       "      <td>-0.001900</td>\n",
       "      <td>-0.029576</td>\n",
       "      <td>-0.019647</td>\n",
       "      <td>0.003540</td>\n",
       "      <td>-0.001384</td>\n",
       "      <td>-0.042085</td>\n",
       "      <td>-0.011841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-08 00:00:00+00:00</th>\n",
       "      <td>-0.023307</td>\n",
       "      <td>-0.026876</td>\n",
       "      <td>-0.008866</td>\n",
       "      <td>-0.000425</td>\n",
       "      <td>0.007114</td>\n",
       "      <td>0.004906</td>\n",
       "      <td>-0.000209</td>\n",
       "      <td>-0.000280</td>\n",
       "      <td>0.023661</td>\n",
       "      <td>-0.008216</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.004606</td>\n",
       "      <td>-0.003910</td>\n",
       "      <td>-0.028251</td>\n",
       "      <td>-0.012067</td>\n",
       "      <td>-0.004930</td>\n",
       "      <td>-0.017074</td>\n",
       "      <td>-0.010735</td>\n",
       "      <td>-0.006277</td>\n",
       "      <td>-0.031813</td>\n",
       "      <td>0.000666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-09 00:00:00+00:00</th>\n",
       "      <td>-0.005170</td>\n",
       "      <td>-0.020213</td>\n",
       "      <td>0.022223</td>\n",
       "      <td>-0.022077</td>\n",
       "      <td>-0.011303</td>\n",
       "      <td>0.001984</td>\n",
       "      <td>-0.012948</td>\n",
       "      <td>-0.014876</td>\n",
       "      <td>-0.023550</td>\n",
       "      <td>-0.023608</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.013092</td>\n",
       "      <td>-0.009934</td>\n",
       "      <td>0.013390</td>\n",
       "      <td>-0.021066</td>\n",
       "      <td>-0.009869</td>\n",
       "      <td>-0.000570</td>\n",
       "      <td>-0.023679</td>\n",
       "      <td>0.002205</td>\n",
       "      <td>-0.007490</td>\n",
       "      <td>-0.015900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-10 00:00:00+00:00</th>\n",
       "      <td>0.015039</td>\n",
       "      <td>0.010092</td>\n",
       "      <td>-0.009466</td>\n",
       "      <td>0.004763</td>\n",
       "      <td>-0.004463</td>\n",
       "      <td>0.012720</td>\n",
       "      <td>0.007772</td>\n",
       "      <td>0.002897</td>\n",
       "      <td>-0.006699</td>\n",
       "      <td>0.008821</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.006757</td>\n",
       "      <td>0.001883</td>\n",
       "      <td>0.000798</td>\n",
       "      <td>-0.000317</td>\n",
       "      <td>0.014970</td>\n",
       "      <td>0.012138</td>\n",
       "      <td>-0.008256</td>\n",
       "      <td>-0.000297</td>\n",
       "      <td>0.014759</td>\n",
       "      <td>0.019695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-11 00:00:00+00:00</th>\n",
       "      <td>-0.012227</td>\n",
       "      <td>-0.045356</td>\n",
       "      <td>-0.019179</td>\n",
       "      <td>-0.025740</td>\n",
       "      <td>-0.031185</td>\n",
       "      <td>0.001280</td>\n",
       "      <td>-0.020962</td>\n",
       "      <td>-0.021380</td>\n",
       "      <td>0.027653</td>\n",
       "      <td>-0.003843</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.014938</td>\n",
       "      <td>-0.012713</td>\n",
       "      <td>-0.017840</td>\n",
       "      <td>-0.017755</td>\n",
       "      <td>-0.012793</td>\n",
       "      <td>-0.013062</td>\n",
       "      <td>-0.025836</td>\n",
       "      <td>-0.010112</td>\n",
       "      <td>-0.029782</td>\n",
       "      <td>-0.005856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-14 00:00:00+00:00</th>\n",
       "      <td>-0.011197</td>\n",
       "      <td>-0.007618</td>\n",
       "      <td>-0.008325</td>\n",
       "      <td>-0.006189</td>\n",
       "      <td>0.025898</td>\n",
       "      <td>0.004406</td>\n",
       "      <td>0.010145</td>\n",
       "      <td>0.010071</td>\n",
       "      <td>0.020127</td>\n",
       "      <td>-0.001938</td>\n",
       "      <td>...</td>\n",
       "      <td>0.007216</td>\n",
       "      <td>-0.000941</td>\n",
       "      <td>0.022738</td>\n",
       "      <td>-0.001835</td>\n",
       "      <td>-0.017913</td>\n",
       "      <td>0.011580</td>\n",
       "      <td>0.004910</td>\n",
       "      <td>0.005356</td>\n",
       "      <td>-0.014991</td>\n",
       "      <td>0.016583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-15 00:00:00+00:00</th>\n",
       "      <td>0.024683</td>\n",
       "      <td>0.019768</td>\n",
       "      <td>0.057990</td>\n",
       "      <td>-0.017686</td>\n",
       "      <td>0.017133</td>\n",
       "      <td>-0.008194</td>\n",
       "      <td>0.017415</td>\n",
       "      <td>0.003386</td>\n",
       "      <td>0.008149</td>\n",
       "      <td>-0.004743</td>\n",
       "      <td>...</td>\n",
       "      <td>0.015392</td>\n",
       "      <td>0.013516</td>\n",
       "      <td>0.044710</td>\n",
       "      <td>0.004357</td>\n",
       "      <td>0.016222</td>\n",
       "      <td>0.001635</td>\n",
       "      <td>0.013410</td>\n",
       "      <td>0.015787</td>\n",
       "      <td>0.035626</td>\n",
       "      <td>0.008156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-16 00:00:00+00:00</th>\n",
       "      <td>0.010780</td>\n",
       "      <td>0.014190</td>\n",
       "      <td>0.029771</td>\n",
       "      <td>0.007685</td>\n",
       "      <td>0.021998</td>\n",
       "      <td>-0.000985</td>\n",
       "      <td>0.010080</td>\n",
       "      <td>0.022107</td>\n",
       "      <td>0.016379</td>\n",
       "      <td>0.017336</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004713</td>\n",
       "      <td>0.000531</td>\n",
       "      <td>-0.003522</td>\n",
       "      <td>0.008507</td>\n",
       "      <td>0.024937</td>\n",
       "      <td>0.020719</td>\n",
       "      <td>0.012809</td>\n",
       "      <td>0.008606</td>\n",
       "      <td>0.010755</td>\n",
       "      <td>0.002538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-17 00:00:00+00:00</th>\n",
       "      <td>-0.017212</td>\n",
       "      <td>-0.017122</td>\n",
       "      <td>-0.048190</td>\n",
       "      <td>-0.021196</td>\n",
       "      <td>-0.021696</td>\n",
       "      <td>0.007386</td>\n",
       "      <td>-0.017153</td>\n",
       "      <td>-0.053355</td>\n",
       "      <td>-0.014232</td>\n",
       "      <td>-0.024510</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.001564</td>\n",
       "      <td>-0.018147</td>\n",
       "      <td>-0.015037</td>\n",
       "      <td>-0.003142</td>\n",
       "      <td>-0.007787</td>\n",
       "      <td>-0.026697</td>\n",
       "      <td>-0.018224</td>\n",
       "      <td>-0.011966</td>\n",
       "      <td>-0.015960</td>\n",
       "      <td>-0.007637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-18 00:00:00+00:00</th>\n",
       "      <td>-0.041084</td>\n",
       "      <td>-0.032259</td>\n",
       "      <td>-0.022863</td>\n",
       "      <td>-0.027064</td>\n",
       "      <td>-0.011342</td>\n",
       "      <td>-0.004497</td>\n",
       "      <td>-0.034461</td>\n",
       "      <td>-0.012883</td>\n",
       "      <td>-0.030679</td>\n",
       "      <td>-0.016940</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.019013</td>\n",
       "      <td>-0.012314</td>\n",
       "      <td>-0.008724</td>\n",
       "      <td>-0.010451</td>\n",
       "      <td>-0.003944</td>\n",
       "      <td>-0.017002</td>\n",
       "      <td>-0.004991</td>\n",
       "      <td>-0.017384</td>\n",
       "      <td>-0.037845</td>\n",
       "      <td>-0.002791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-21 00:00:00+00:00</th>\n",
       "      <td>0.009455</td>\n",
       "      <td>0.031863</td>\n",
       "      <td>0.000531</td>\n",
       "      <td>0.012254</td>\n",
       "      <td>0.008245</td>\n",
       "      <td>0.009916</td>\n",
       "      <td>0.007778</td>\n",
       "      <td>0.010404</td>\n",
       "      <td>0.003395</td>\n",
       "      <td>0.011962</td>\n",
       "      <td>...</td>\n",
       "      <td>0.006358</td>\n",
       "      <td>0.016776</td>\n",
       "      <td>-0.000255</td>\n",
       "      <td>0.007035</td>\n",
       "      <td>0.014779</td>\n",
       "      <td>0.008360</td>\n",
       "      <td>0.021714</td>\n",
       "      <td>0.012842</td>\n",
       "      <td>0.002271</td>\n",
       "      <td>0.015894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-22 00:00:00+00:00</th>\n",
       "      <td>0.010502</td>\n",
       "      <td>0.011670</td>\n",
       "      <td>-0.011760</td>\n",
       "      <td>-0.000927</td>\n",
       "      <td>0.024746</td>\n",
       "      <td>0.002617</td>\n",
       "      <td>0.009978</td>\n",
       "      <td>0.007473</td>\n",
       "      <td>0.024012</td>\n",
       "      <td>0.003326</td>\n",
       "      <td>...</td>\n",
       "      <td>0.031671</td>\n",
       "      <td>0.002735</td>\n",
       "      <td>0.005054</td>\n",
       "      <td>0.010047</td>\n",
       "      <td>0.038863</td>\n",
       "      <td>0.009977</td>\n",
       "      <td>-0.005448</td>\n",
       "      <td>0.014966</td>\n",
       "      <td>0.014553</td>\n",
       "      <td>0.008027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-23 00:00:00+00:00</th>\n",
       "      <td>0.011803</td>\n",
       "      <td>0.009219</td>\n",
       "      <td>0.008325</td>\n",
       "      <td>0.012869</td>\n",
       "      <td>0.017178</td>\n",
       "      <td>0.007567</td>\n",
       "      <td>0.013950</td>\n",
       "      <td>0.006365</td>\n",
       "      <td>0.009380</td>\n",
       "      <td>0.008296</td>\n",
       "      <td>...</td>\n",
       "      <td>0.009199</td>\n",
       "      <td>0.009501</td>\n",
       "      <td>0.032702</td>\n",
       "      <td>0.007586</td>\n",
       "      <td>0.011193</td>\n",
       "      <td>0.017237</td>\n",
       "      <td>0.015349</td>\n",
       "      <td>0.010219</td>\n",
       "      <td>0.018773</td>\n",
       "      <td>0.005444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-24 00:00:00+00:00</th>\n",
       "      <td>-0.003682</td>\n",
       "      <td>0.012022</td>\n",
       "      <td>0.000465</td>\n",
       "      <td>-0.005341</td>\n",
       "      <td>-0.002041</td>\n",
       "      <td>0.000090</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.001820</td>\n",
       "      <td>-0.004224</td>\n",
       "      <td>0.005673</td>\n",
       "      <td>...</td>\n",
       "      <td>0.009623</td>\n",
       "      <td>-0.000620</td>\n",
       "      <td>-0.010724</td>\n",
       "      <td>-0.002127</td>\n",
       "      <td>0.005553</td>\n",
       "      <td>-0.001614</td>\n",
       "      <td>-0.001620</td>\n",
       "      <td>0.001364</td>\n",
       "      <td>0.003975</td>\n",
       "      <td>0.003121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-28 00:00:00+00:00</th>\n",
       "      <td>0.007040</td>\n",
       "      <td>-0.013259</td>\n",
       "      <td>0.009526</td>\n",
       "      <td>-0.011204</td>\n",
       "      <td>0.004953</td>\n",
       "      <td>0.002309</td>\n",
       "      <td>-0.001550</td>\n",
       "      <td>-0.001441</td>\n",
       "      <td>-0.001060</td>\n",
       "      <td>-0.006164</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000503</td>\n",
       "      <td>-0.001064</td>\n",
       "      <td>-0.007439</td>\n",
       "      <td>0.004930</td>\n",
       "      <td>-0.021138</td>\n",
       "      <td>-0.003484</td>\n",
       "      <td>-0.002177</td>\n",
       "      <td>-0.006413</td>\n",
       "      <td>-0.005033</td>\n",
       "      <td>-0.004784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-29 00:00:00+00:00</th>\n",
       "      <td>0.019443</td>\n",
       "      <td>0.006256</td>\n",
       "      <td>0.010957</td>\n",
       "      <td>0.017976</td>\n",
       "      <td>0.011911</td>\n",
       "      <td>0.005569</td>\n",
       "      <td>0.017542</td>\n",
       "      <td>0.011914</td>\n",
       "      <td>0.011996</td>\n",
       "      <td>0.015224</td>\n",
       "      <td>...</td>\n",
       "      <td>0.013813</td>\n",
       "      <td>0.007964</td>\n",
       "      <td>0.005336</td>\n",
       "      <td>0.011436</td>\n",
       "      <td>0.011283</td>\n",
       "      <td>0.004307</td>\n",
       "      <td>0.005415</td>\n",
       "      <td>0.007235</td>\n",
       "      <td>0.006174</td>\n",
       "      <td>0.008997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-30 00:00:00+00:00</th>\n",
       "      <td>-0.006384</td>\n",
       "      <td>-0.016085</td>\n",
       "      <td>-0.005254</td>\n",
       "      <td>-0.013056</td>\n",
       "      <td>0.005904</td>\n",
       "      <td>0.002391</td>\n",
       "      <td>-0.012017</td>\n",
       "      <td>0.005124</td>\n",
       "      <td>-0.000524</td>\n",
       "      <td>-0.013256</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.014617</td>\n",
       "      <td>-0.007064</td>\n",
       "      <td>-0.013261</td>\n",
       "      <td>-0.008079</td>\n",
       "      <td>0.001847</td>\n",
       "      <td>-0.006182</td>\n",
       "      <td>-0.005781</td>\n",
       "      <td>-0.002921</td>\n",
       "      <td>-0.012235</td>\n",
       "      <td>-0.001454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-12-31 00:00:00+00:00</th>\n",
       "      <td>-0.012432</td>\n",
       "      <td>-0.010532</td>\n",
       "      <td>-0.005879</td>\n",
       "      <td>-0.019199</td>\n",
       "      <td>-0.009372</td>\n",
       "      <td>-0.012481</td>\n",
       "      <td>-0.007953</td>\n",
       "      <td>-0.012844</td>\n",
       "      <td>-0.014064</td>\n",
       "      <td>-0.021745</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.016052</td>\n",
       "      <td>-0.018175</td>\n",
       "      <td>-0.002050</td>\n",
       "      <td>-0.009119</td>\n",
       "      <td>-0.008371</td>\n",
       "      <td>-0.010031</td>\n",
       "      <td>-0.010299</td>\n",
       "      <td>0.001176</td>\n",
       "      <td>-0.006212</td>\n",
       "      <td>-0.007051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-01-04 00:00:00+00:00</th>\n",
       "      <td>-0.028282</td>\n",
       "      <td>-0.033988</td>\n",
       "      <td>0.011494</td>\n",
       "      <td>0.000855</td>\n",
       "      <td>-0.027512</td>\n",
       "      <td>-0.017741</td>\n",
       "      <td>-0.044067</td>\n",
       "      <td>-0.025551</td>\n",
       "      <td>-0.020971</td>\n",
       "      <td>-0.015919</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.024767</td>\n",
       "      <td>-0.024922</td>\n",
       "      <td>-0.006276</td>\n",
       "      <td>-0.032711</td>\n",
       "      <td>-0.031051</td>\n",
       "      <td>-0.011520</td>\n",
       "      <td>-0.011489</td>\n",
       "      <td>-0.007604</td>\n",
       "      <td>-0.021614</td>\n",
       "      <td>-0.013564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-01-05 00:00:00+00:00</th>\n",
       "      <td>0.004058</td>\n",
       "      <td>-0.009541</td>\n",
       "      <td>-0.006830</td>\n",
       "      <td>-0.025054</td>\n",
       "      <td>-0.004169</td>\n",
       "      <td>0.014629</td>\n",
       "      <td>-0.000247</td>\n",
       "      <td>0.005207</td>\n",
       "      <td>0.004023</td>\n",
       "      <td>-0.007347</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002098</td>\n",
       "      <td>0.014863</td>\n",
       "      <td>0.008511</td>\n",
       "      <td>0.020390</td>\n",
       "      <td>-0.001957</td>\n",
       "      <td>-0.000286</td>\n",
       "      <td>-0.002495</td>\n",
       "      <td>0.020820</td>\n",
       "      <td>-0.010853</td>\n",
       "      <td>0.015647</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1256 rows × 490 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Equity(0 [A])  Equity(1 [AAL])  Equity(2 [AAP])  \\\n",
       "2011-01-07 00:00:00+00:00       0.008437         0.014230         0.026702   \n",
       "2011-01-10 00:00:00+00:00      -0.004174         0.006195         0.007435   \n",
       "2011-01-11 00:00:00+00:00      -0.001886        -0.043644        -0.005927   \n",
       "2011-01-12 00:00:00+00:00       0.017254        -0.008237         0.013387   \n",
       "2011-01-13 00:00:00+00:00      -0.004559         0.000955         0.003031   \n",
       "2011-01-14 00:00:00+00:00       0.003439        -0.009156         0.003022   \n",
       "2011-01-18 00:00:00+00:00       0.034254        -0.062085        -0.004286   \n",
       "2011-01-19 00:00:00+00:00      -0.010224        -0.008929         0.008754   \n",
       "2011-01-20 00:00:00+00:00      -0.008496         0.021953        -0.004732   \n",
       "2011-01-21 00:00:00+00:00       0.007873        -0.041038         0.005544   \n",
       "2011-01-24 00:00:00+00:00       0.014646         0.027473        -0.001106   \n",
       "2011-01-25 00:00:00+00:00      -0.006736         0.002982         0.009146   \n",
       "2011-01-26 00:00:00+00:00      -0.030736         0.066133         0.003593   \n",
       "2011-01-27 00:00:00+00:00       0.007721         0.023178        -0.001553   \n",
       "2011-01-28 00:00:00+00:00      -0.018846        -0.080553        -0.000936   \n",
       "2011-01-31 00:00:00+00:00       0.003608        -0.023615        -0.002351   \n",
       "2011-02-01 00:00:00+00:00       0.011654        -0.001047        -0.009218   \n",
       "2011-02-02 00:00:00+00:00       0.010112        -0.039304        -0.027477   \n",
       "2011-02-03 00:00:00+00:00      -0.000289         0.007310         0.014126   \n",
       "2011-02-04 00:00:00+00:00       0.005627        -0.036500         0.024014   \n",
       "2011-02-07 00:00:00+00:00       0.007709         0.052046         0.008114   \n",
       "2011-02-08 00:00:00+00:00       0.010854         0.016455         0.006202   \n",
       "2011-02-09 00:00:00+00:00       0.004664         0.000000         0.016955   \n",
       "2011-02-10 00:00:00+00:00       0.000413        -0.003048        -0.011367   \n",
       "2011-02-11 00:00:00+00:00      -0.007150         0.028364         0.000764   \n",
       "2011-02-14 00:00:00+00:00       0.001663        -0.015790        -0.023274   \n",
       "2011-02-15 00:00:00+00:00      -0.011905         0.011043        -0.003926   \n",
       "2011-02-16 00:00:00+00:00       0.015123         0.001958         0.013860   \n",
       "2011-02-17 00:00:00+00:00      -0.003311        -0.017791        -0.024844   \n",
       "2011-02-18 00:00:00+00:00       0.011078        -0.020103        -0.006693   \n",
       "...                                  ...              ...              ...   \n",
       "2015-11-20 00:00:00+00:00       0.001072        -0.002373         0.002767   \n",
       "2015-11-23 00:00:00+00:00      -0.007094         0.002379        -0.001228   \n",
       "2015-11-24 00:00:00+00:00       0.002085        -0.025309         0.003504   \n",
       "2015-11-25 00:00:00+00:00      -0.008206         0.001938         0.006805   \n",
       "2015-11-27 00:00:00+00:00      -0.003256         0.009201         0.003285   \n",
       "2015-11-30 00:00:00+00:00      -0.010209        -0.010321        -0.012798   \n",
       "2015-12-01 00:00:00+00:00       0.015748         0.048493        -0.002396   \n",
       "2015-12-02 00:00:00+00:00      -0.005284         0.012930        -0.027166   \n",
       "2015-12-03 00:00:00+00:00      -0.009521        -0.012555        -0.019944   \n",
       "2015-12-04 00:00:00+00:00       0.020199         0.039303         0.006779   \n",
       "2015-12-07 00:00:00+00:00      -0.000340         0.018020        -0.029578   \n",
       "2015-12-08 00:00:00+00:00      -0.023307        -0.026876        -0.008866   \n",
       "2015-12-09 00:00:00+00:00      -0.005170        -0.020213         0.022223   \n",
       "2015-12-10 00:00:00+00:00       0.015039         0.010092        -0.009466   \n",
       "2015-12-11 00:00:00+00:00      -0.012227        -0.045356        -0.019179   \n",
       "2015-12-14 00:00:00+00:00      -0.011197        -0.007618        -0.008325   \n",
       "2015-12-15 00:00:00+00:00       0.024683         0.019768         0.057990   \n",
       "2015-12-16 00:00:00+00:00       0.010780         0.014190         0.029771   \n",
       "2015-12-17 00:00:00+00:00      -0.017212        -0.017122        -0.048190   \n",
       "2015-12-18 00:00:00+00:00      -0.041084        -0.032259        -0.022863   \n",
       "2015-12-21 00:00:00+00:00       0.009455         0.031863         0.000531   \n",
       "2015-12-22 00:00:00+00:00       0.010502         0.011670        -0.011760   \n",
       "2015-12-23 00:00:00+00:00       0.011803         0.009219         0.008325   \n",
       "2015-12-24 00:00:00+00:00      -0.003682         0.012022         0.000465   \n",
       "2015-12-28 00:00:00+00:00       0.007040        -0.013259         0.009526   \n",
       "2015-12-29 00:00:00+00:00       0.019443         0.006256         0.010957   \n",
       "2015-12-30 00:00:00+00:00      -0.006384        -0.016085        -0.005254   \n",
       "2015-12-31 00:00:00+00:00      -0.012432        -0.010532        -0.005879   \n",
       "2016-01-04 00:00:00+00:00      -0.028282        -0.033988         0.011494   \n",
       "2016-01-05 00:00:00+00:00       0.004058        -0.009541        -0.006830   \n",
       "\n",
       "                           Equity(3 [AAPL])  Equity(4 [ABBV])  \\\n",
       "2011-01-07 00:00:00+00:00          0.007146          0.000000   \n",
       "2011-01-10 00:00:00+00:00          0.018852          0.000000   \n",
       "2011-01-11 00:00:00+00:00         -0.002367          0.000000   \n",
       "2011-01-12 00:00:00+00:00          0.008133          0.000000   \n",
       "2011-01-13 00:00:00+00:00          0.003657          0.000000   \n",
       "2011-01-14 00:00:00+00:00          0.008106          0.000000   \n",
       "2011-01-18 00:00:00+00:00         -0.022474          0.000000   \n",
       "2011-01-19 00:00:00+00:00         -0.005314          0.000000   \n",
       "2011-01-20 00:00:00+00:00         -0.018189          0.000000   \n",
       "2011-01-21 00:00:00+00:00         -0.017911          0.000000   \n",
       "2011-01-24 00:00:00+00:00          0.032837          0.000000   \n",
       "2011-01-25 00:00:00+00:00          0.011710          0.000000   \n",
       "2011-01-26 00:00:00+00:00          0.007193          0.000000   \n",
       "2011-01-27 00:00:00+00:00         -0.001877          0.000000   \n",
       "2011-01-28 00:00:00+00:00         -0.020710          0.000000   \n",
       "2011-01-31 00:00:00+00:00          0.009578          0.000000   \n",
       "2011-02-01 00:00:00+00:00          0.016818          0.000000   \n",
       "2011-02-02 00:00:00+00:00         -0.002053          0.000000   \n",
       "2011-02-03 00:00:00+00:00         -0.002560          0.000000   \n",
       "2011-02-04 00:00:00+00:00          0.008915          0.000000   \n",
       "2011-02-07 00:00:00+00:00          0.015538          0.000000   \n",
       "2011-02-08 00:00:00+00:00          0.009440          0.000000   \n",
       "2011-02-09 00:00:00+00:00          0.008332          0.000000   \n",
       "2011-02-10 00:00:00+00:00         -0.010109          0.000000   \n",
       "2011-02-11 00:00:00+00:00          0.006505          0.000000   \n",
       "2011-02-14 00:00:00+00:00          0.006529          0.000000   \n",
       "2011-02-15 00:00:00+00:00          0.002016          0.000000   \n",
       "2011-02-16 00:00:00+00:00          0.008967          0.000000   \n",
       "2011-02-17 00:00:00+00:00         -0.013309          0.000000   \n",
       "2011-02-18 00:00:00+00:00         -0.021595          0.000000   \n",
       "...                                     ...               ...   \n",
       "2015-11-20 00:00:00+00:00          0.004381          0.009256   \n",
       "2015-11-23 00:00:00+00:00         -0.012989          0.000646   \n",
       "2015-11-24 00:00:00+00:00          0.009594         -0.000323   \n",
       "2015-11-25 00:00:00+00:00         -0.007151         -0.013744   \n",
       "2015-11-27 00:00:00+00:00         -0.001863         -0.004803   \n",
       "2015-11-30 00:00:00+00:00          0.004159         -0.030838   \n",
       "2015-12-01 00:00:00+00:00         -0.008116          0.014957   \n",
       "2015-12-02 00:00:00+00:00         -0.009030         -0.022022   \n",
       "2015-12-03 00:00:00+00:00         -0.009292         -0.027724   \n",
       "2015-12-04 00:00:00+00:00          0.033246          0.018899   \n",
       "2015-12-07 00:00:00+00:00         -0.006298         -0.015921   \n",
       "2015-12-08 00:00:00+00:00         -0.000425          0.007114   \n",
       "2015-12-09 00:00:00+00:00         -0.022077         -0.011303   \n",
       "2015-12-10 00:00:00+00:00          0.004763         -0.004463   \n",
       "2015-12-11 00:00:00+00:00         -0.025740         -0.031185   \n",
       "2015-12-14 00:00:00+00:00         -0.006189          0.025898   \n",
       "2015-12-15 00:00:00+00:00         -0.017686          0.017133   \n",
       "2015-12-16 00:00:00+00:00          0.007685          0.021998   \n",
       "2015-12-17 00:00:00+00:00         -0.021196         -0.021696   \n",
       "2015-12-18 00:00:00+00:00         -0.027064         -0.011342   \n",
       "2015-12-21 00:00:00+00:00          0.012254          0.008245   \n",
       "2015-12-22 00:00:00+00:00         -0.000927          0.024746   \n",
       "2015-12-23 00:00:00+00:00          0.012869          0.017178   \n",
       "2015-12-24 00:00:00+00:00         -0.005341         -0.002041   \n",
       "2015-12-28 00:00:00+00:00         -0.011204          0.004953   \n",
       "2015-12-29 00:00:00+00:00          0.017976          0.011911   \n",
       "2015-12-30 00:00:00+00:00         -0.013056          0.005904   \n",
       "2015-12-31 00:00:00+00:00         -0.019199         -0.009372   \n",
       "2016-01-04 00:00:00+00:00          0.000855         -0.027512   \n",
       "2016-01-05 00:00:00+00:00         -0.025054         -0.004169   \n",
       "\n",
       "                           Equity(5 [ABC])  Equity(6 [ABT])  Equity(7 [ACN])  \\\n",
       "2011-01-07 00:00:00+00:00         0.001994         0.004165         0.001648   \n",
       "2011-01-10 00:00:00+00:00        -0.005714        -0.008896        -0.008854   \n",
       "2011-01-11 00:00:00+00:00         0.009783        -0.002067         0.013717   \n",
       "2011-01-12 00:00:00+00:00        -0.005979        -0.001011         0.022969   \n",
       "2011-01-13 00:00:00+00:00         0.014925        -0.004451        -0.000400   \n",
       "2011-01-14 00:00:00+00:00         0.001395        -0.010111         0.002590   \n",
       "2011-01-18 00:00:00+00:00         0.020889         0.006621         0.006998   \n",
       "2011-01-19 00:00:00+00:00        -0.017144         0.002753        -0.002962   \n",
       "2011-01-20 00:00:00+00:00         0.004794         0.013322         0.018713   \n",
       "2011-01-21 00:00:00+00:00         0.010642        -0.000853        -0.001952   \n",
       "2011-01-24 00:00:00+00:00         0.005249         0.005223         0.008420   \n",
       "2011-01-25 00:00:00+00:00        -0.009363        -0.004347         0.004859   \n",
       "2011-01-26 00:00:00+00:00         0.012227        -0.025241         0.012192   \n",
       "2011-01-27 00:00:00+00:00         0.011833        -0.007928         0.000179   \n",
       "2011-01-28 00:00:00+00:00        -0.022262        -0.019200        -0.016035   \n",
       "2011-01-31 00:00:00+00:00        -0.003893        -0.007248        -0.000980   \n",
       "2011-02-01 00:00:00+00:00         0.011976         0.001546         0.017498   \n",
       "2011-02-02 00:00:00+00:00        -0.021197         0.011068         0.003632   \n",
       "2011-02-03 00:00:00+00:00        -0.003662         0.005894         0.004178   \n",
       "2011-02-04 00:00:00+00:00         0.033047         0.002616        -0.004360   \n",
       "2011-02-07 00:00:00+00:00        -0.002178        -0.009341         0.002279   \n",
       "2011-02-08 00:00:00+00:00         0.002182        -0.001738        -0.000557   \n",
       "2011-02-09 00:00:00+00:00         0.003006        -0.001530         0.001138   \n",
       "2011-02-10 00:00:00+00:00         0.001101        -0.001110         0.005503   \n",
       "2011-02-11 00:00:00+00:00        -0.001375         0.001534        -0.011146   \n",
       "2011-02-14 00:00:00+00:00         0.005750         0.009245         0.000202   \n",
       "2011-02-15 00:00:00+00:00        -0.007329         0.016750        -0.008021   \n",
       "2011-02-16 00:00:00+00:00        -0.003554        -0.010502         0.027329   \n",
       "2011-02-17 00:00:00+00:00         0.029148         0.001301         0.011784   \n",
       "2011-02-18 00:00:00+00:00         0.009620         0.012106        -0.007953   \n",
       "...                                    ...              ...              ...   \n",
       "2015-11-20 00:00:00+00:00        -0.000905         0.006113         0.006430   \n",
       "2015-11-23 00:00:00+00:00        -0.003728        -0.012381        -0.001206   \n",
       "2015-11-24 00:00:00+00:00        -0.002336         0.000210        -0.004537   \n",
       "2015-11-25 00:00:00+00:00         0.004365        -0.000862        -0.002338   \n",
       "2015-11-27 00:00:00+00:00         0.000612         0.000210         0.003363   \n",
       "2015-11-30 00:00:00+00:00        -0.003542        -0.011004        -0.002228   \n",
       "2015-12-01 00:00:00+00:00         0.008718         0.012022         0.008480   \n",
       "2015-12-02 00:00:00+00:00        -0.006534        -0.005287        -0.004991   \n",
       "2015-12-03 00:00:00+00:00        -0.001415        -0.023650        -0.015429   \n",
       "2015-12-04 00:00:00+00:00         0.011957         0.026046         0.029924   \n",
       "2015-12-07 00:00:00+00:00         0.000898         0.005727        -0.001463   \n",
       "2015-12-08 00:00:00+00:00         0.004906        -0.000209        -0.000280   \n",
       "2015-12-09 00:00:00+00:00         0.001984        -0.012948        -0.014876   \n",
       "2015-12-10 00:00:00+00:00         0.012720         0.007772         0.002897   \n",
       "2015-12-11 00:00:00+00:00         0.001280        -0.020962        -0.021380   \n",
       "2015-12-14 00:00:00+00:00         0.004406         0.010145         0.010071   \n",
       "2015-12-15 00:00:00+00:00        -0.008194         0.017415         0.003386   \n",
       "2015-12-16 00:00:00+00:00        -0.000985         0.010080         0.022107   \n",
       "2015-12-17 00:00:00+00:00         0.007386        -0.017153        -0.053355   \n",
       "2015-12-18 00:00:00+00:00        -0.004497        -0.034461        -0.012883   \n",
       "2015-12-21 00:00:00+00:00         0.009916         0.007778         0.010404   \n",
       "2015-12-22 00:00:00+00:00         0.002617         0.009978         0.007473   \n",
       "2015-12-23 00:00:00+00:00         0.007567         0.013950         0.006365   \n",
       "2015-12-24 00:00:00+00:00         0.000090         0.000000        -0.001820   \n",
       "2015-12-28 00:00:00+00:00         0.002309        -0.001550        -0.001441   \n",
       "2015-12-29 00:00:00+00:00         0.005569         0.017542         0.011914   \n",
       "2015-12-30 00:00:00+00:00         0.002391        -0.012017         0.005124   \n",
       "2015-12-31 00:00:00+00:00        -0.012481        -0.007953        -0.012844   \n",
       "2016-01-04 00:00:00+00:00        -0.017741        -0.044067        -0.025551   \n",
       "2016-01-05 00:00:00+00:00         0.014629        -0.000247         0.005207   \n",
       "\n",
       "                           Equity(8 [ADBE])  Equity(9 [ADI])  \\\n",
       "2011-01-07 00:00:00+00:00         -0.007127        -0.005818   \n",
       "2011-01-10 00:00:00+00:00          0.028714         0.002926   \n",
       "2011-01-11 00:00:00+00:00          0.000607         0.008753   \n",
       "2011-01-12 00:00:00+00:00          0.017950         0.000257   \n",
       "2011-01-13 00:00:00+00:00         -0.005719        -0.005012   \n",
       "2011-01-14 00:00:00+00:00          0.012283         0.019827   \n",
       "2011-01-18 00:00:00+00:00          0.011542         0.032645   \n",
       "2011-01-19 00:00:00+00:00         -0.007899        -0.020575   \n",
       "2011-01-20 00:00:00+00:00         -0.012386        -0.002818   \n",
       "2011-01-21 00:00:00+00:00         -0.006569        -0.004113   \n",
       "2011-01-24 00:00:00+00:00          0.022843         0.014974   \n",
       "2011-01-25 00:00:00+00:00         -0.013811        -0.014505   \n",
       "2011-01-26 00:00:00+00:00         -0.001192         0.002837   \n",
       "2011-01-27 00:00:00+00:00          0.009845         0.007480   \n",
       "2011-01-28 00:00:00+00:00         -0.040177        -0.022460   \n",
       "2011-01-31 00:00:00+00:00          0.017236         0.013818   \n",
       "2011-02-01 00:00:00+00:00          0.013918         0.021624   \n",
       "2011-02-02 00:00:00+00:00         -0.002387         0.002280   \n",
       "2011-02-03 00:00:00+00:00          0.002991        -0.013341   \n",
       "2011-02-04 00:00:00+00:00         -0.005070         0.019659   \n",
       "2011-02-07 00:00:00+00:00          0.005995        -0.003514   \n",
       "2011-02-08 00:00:00+00:00          0.000298        -0.006010   \n",
       "2011-02-09 00:00:00+00:00         -0.016682         0.004781   \n",
       "2011-02-10 00:00:00+00:00          0.016965         0.004513   \n",
       "2011-02-11 00:00:00+00:00          0.002979         0.015007   \n",
       "2011-02-14 00:00:00+00:00          0.005643         0.009877   \n",
       "2011-02-15 00:00:00+00:00          0.002363         0.000239   \n",
       "2011-02-16 00:00:00+00:00          0.022098        -0.003905   \n",
       "2011-02-17 00:00:00+00:00          0.008360         0.008559   \n",
       "2011-02-18 00:00:00+00:00          0.011721        -0.001691   \n",
       "...                                     ...              ...   \n",
       "2015-11-20 00:00:00+00:00          0.000545        -0.005843   \n",
       "2015-11-23 00:00:00+00:00          0.001634        -0.044107   \n",
       "2015-11-24 00:00:00+00:00          0.000435         0.063741   \n",
       "2015-11-25 00:00:00+00:00         -0.002500        -0.002810   \n",
       "2015-11-27 00:00:00+00:00          0.004359         0.003315   \n",
       "2015-11-30 00:00:00+00:00         -0.007703         0.019522   \n",
       "2015-12-01 00:00:00+00:00          0.011918        -0.000970   \n",
       "2015-12-02 00:00:00+00:00         -0.005727        -0.006990   \n",
       "2015-12-03 00:00:00+00:00         -0.022930        -0.027826   \n",
       "2015-12-04 00:00:00+00:00          0.029696         0.002713   \n",
       "2015-12-07 00:00:00+00:00         -0.032188        -0.011988   \n",
       "2015-12-08 00:00:00+00:00          0.023661        -0.008216   \n",
       "2015-12-09 00:00:00+00:00         -0.023550        -0.023608   \n",
       "2015-12-10 00:00:00+00:00         -0.006699         0.008821   \n",
       "2015-12-11 00:00:00+00:00          0.027653        -0.003843   \n",
       "2015-12-14 00:00:00+00:00          0.020127        -0.001938   \n",
       "2015-12-15 00:00:00+00:00          0.008149        -0.004743   \n",
       "2015-12-16 00:00:00+00:00          0.016379         0.017336   \n",
       "2015-12-17 00:00:00+00:00         -0.014232        -0.024510   \n",
       "2015-12-18 00:00:00+00:00         -0.030679        -0.016940   \n",
       "2015-12-21 00:00:00+00:00          0.003395         0.011962   \n",
       "2015-12-22 00:00:00+00:00          0.024012         0.003326   \n",
       "2015-12-23 00:00:00+00:00          0.009380         0.008296   \n",
       "2015-12-24 00:00:00+00:00         -0.004224         0.005673   \n",
       "2015-12-28 00:00:00+00:00         -0.001060        -0.006164   \n",
       "2015-12-29 00:00:00+00:00          0.011996         0.015224   \n",
       "2015-12-30 00:00:00+00:00         -0.000524        -0.013256   \n",
       "2015-12-31 00:00:00+00:00         -0.014064        -0.021745   \n",
       "2016-01-04 00:00:00+00:00         -0.020971        -0.015919   \n",
       "2016-01-05 00:00:00+00:00          0.004023        -0.007347   \n",
       "\n",
       "                                 ...          Equity(481 [XL])  \\\n",
       "2011-01-07 00:00:00+00:00        ...                 -0.001838   \n",
       "2011-01-10 00:00:00+00:00        ...                  0.000947   \n",
       "2011-01-11 00:00:00+00:00        ...                  0.001314   \n",
       "2011-01-12 00:00:00+00:00        ...                  0.004986   \n",
       "2011-01-13 00:00:00+00:00        ...                  0.030499   \n",
       "2011-01-14 00:00:00+00:00        ...                  0.026607   \n",
       "2011-01-18 00:00:00+00:00        ...                  0.001678   \n",
       "2011-01-19 00:00:00+00:00        ...                 -0.014834   \n",
       "2011-01-20 00:00:00+00:00        ...                 -0.024512   \n",
       "2011-01-21 00:00:00+00:00        ...                  0.000000   \n",
       "2011-01-24 00:00:00+00:00        ...                  0.012359   \n",
       "2011-01-25 00:00:00+00:00        ...                  0.002178   \n",
       "2011-01-26 00:00:00+00:00        ...                  0.002628   \n",
       "2011-01-27 00:00:00+00:00        ...                  0.014267   \n",
       "2011-01-28 00:00:00+00:00        ...                 -0.025647   \n",
       "2011-01-31 00:00:00+00:00        ...                  0.004846   \n",
       "2011-02-01 00:00:00+00:00        ...                  0.015687   \n",
       "2011-02-02 00:00:00+00:00        ...                 -0.012846   \n",
       "2011-02-03 00:00:00+00:00        ...                  0.010430   \n",
       "2011-02-04 00:00:00+00:00        ...                  0.009471   \n",
       "2011-02-07 00:00:00+00:00        ...                  0.006801   \n",
       "2011-02-08 00:00:00+00:00        ...                  0.003846   \n",
       "2011-02-09 00:00:00+00:00        ...                 -0.011837   \n",
       "2011-02-10 00:00:00+00:00        ...                 -0.008947   \n",
       "2011-02-11 00:00:00+00:00        ...                  0.001705   \n",
       "2011-02-14 00:00:00+00:00        ...                 -0.011616   \n",
       "2011-02-15 00:00:00+00:00        ...                 -0.006079   \n",
       "2011-02-16 00:00:00+00:00        ...                  0.009174   \n",
       "2011-02-17 00:00:00+00:00        ...                  0.015656   \n",
       "2011-02-18 00:00:00+00:00        ...                  0.053404   \n",
       "...                              ...                       ...   \n",
       "2015-11-20 00:00:00+00:00        ...                  0.008131   \n",
       "2015-11-23 00:00:00+00:00        ...                 -0.004696   \n",
       "2015-11-24 00:00:00+00:00        ...                 -0.000777   \n",
       "2015-11-25 00:00:00+00:00        ...                 -0.008888   \n",
       "2015-11-27 00:00:00+00:00        ...                  0.004736   \n",
       "2015-11-30 00:00:00+00:00        ...                  0.004212   \n",
       "2015-12-01 00:00:00+00:00        ...                  0.015192   \n",
       "2015-12-02 00:00:00+00:00        ...                 -0.003858   \n",
       "2015-12-03 00:00:00+00:00        ...                 -0.008294   \n",
       "2015-12-04 00:00:00+00:00        ...                  0.022211   \n",
       "2015-12-07 00:00:00+00:00        ...                  0.000000   \n",
       "2015-12-08 00:00:00+00:00        ...                 -0.004606   \n",
       "2015-12-09 00:00:00+00:00        ...                 -0.013092   \n",
       "2015-12-10 00:00:00+00:00        ...                 -0.006757   \n",
       "2015-12-11 00:00:00+00:00        ...                 -0.014938   \n",
       "2015-12-14 00:00:00+00:00        ...                  0.007216   \n",
       "2015-12-15 00:00:00+00:00        ...                  0.015392   \n",
       "2015-12-16 00:00:00+00:00        ...                  0.004713   \n",
       "2015-12-17 00:00:00+00:00        ...                 -0.001564   \n",
       "2015-12-18 00:00:00+00:00        ...                 -0.019013   \n",
       "2015-12-21 00:00:00+00:00        ...                  0.006358   \n",
       "2015-12-22 00:00:00+00:00        ...                  0.031671   \n",
       "2015-12-23 00:00:00+00:00        ...                  0.009199   \n",
       "2015-12-24 00:00:00+00:00        ...                  0.009623   \n",
       "2015-12-28 00:00:00+00:00        ...                  0.000503   \n",
       "2015-12-29 00:00:00+00:00        ...                  0.013813   \n",
       "2015-12-30 00:00:00+00:00        ...                 -0.014617   \n",
       "2015-12-31 00:00:00+00:00        ...                 -0.016052   \n",
       "2016-01-04 00:00:00+00:00        ...                 -0.024767   \n",
       "2016-01-05 00:00:00+00:00        ...                  0.002098   \n",
       "\n",
       "                           Equity(482 [XLNX])  Equity(483 [XOM])  \\\n",
       "2011-01-07 00:00:00+00:00           -0.005619           0.005461   \n",
       "2011-01-10 00:00:00+00:00            0.007814          -0.006081   \n",
       "2011-01-11 00:00:00+00:00            0.010179           0.007442   \n",
       "2011-01-12 00:00:00+00:00            0.015666           0.011763   \n",
       "2011-01-13 00:00:00+00:00           -0.003217           0.001694   \n",
       "2011-01-14 00:00:00+00:00            0.025894           0.014743   \n",
       "2011-01-18 00:00:00+00:00            0.002501           0.011163   \n",
       "2011-01-19 00:00:00+00:00           -0.023590          -0.005968   \n",
       "2011-01-20 00:00:00+00:00            0.007744          -0.006261   \n",
       "2011-01-21 00:00:00+00:00            0.000615           0.015825   \n",
       "2011-01-24 00:00:00+00:00            0.016011          -0.004943   \n",
       "2011-01-25 00:00:00+00:00            0.006273           0.001154   \n",
       "2011-01-26 00:00:00+00:00            0.005934           0.012453   \n",
       "2011-01-27 00:00:00+00:00            0.021169           0.002751   \n",
       "2011-01-28 00:00:00+00:00           -0.020108          -0.011131   \n",
       "2011-01-31 00:00:00+00:00            0.000298           0.021396   \n",
       "2011-02-01 00:00:00+00:00            0.032003           0.040037   \n",
       "2011-02-02 00:00:00+00:00           -0.004518          -0.005958   \n",
       "2011-02-03 00:00:00+00:00           -0.008169           0.000347   \n",
       "2011-02-04 00:00:00+00:00            0.024709          -0.001917   \n",
       "2011-02-07 00:00:00+00:00           -0.005073           0.007803   \n",
       "2011-02-08 00:00:00+00:00            0.001795          -0.006077   \n",
       "2011-02-09 00:00:00+00:00           -0.001792          -0.005178   \n",
       "2011-02-10 00:00:00+00:00            0.003914           0.007876   \n",
       "2011-02-11 00:00:00+00:00            0.010765          -0.004562   \n",
       "2011-02-14 00:00:00+00:00            0.000318           0.025230   \n",
       "2011-02-15 00:00:00+00:00           -0.001804          -0.022853   \n",
       "2011-02-16 00:00:00+00:00            0.003863           0.008682   \n",
       "2011-02-17 00:00:00+00:00            0.000318           0.002275   \n",
       "2011-02-18 00:00:00+00:00            0.001447           0.007393   \n",
       "...                                       ...                ...   \n",
       "2015-11-20 00:00:00+00:00            0.000412          -0.006352   \n",
       "2015-11-23 00:00:00+00:00           -0.006955           0.006131   \n",
       "2015-11-24 00:00:00+00:00            0.012960           0.019935   \n",
       "2015-11-25 00:00:00+00:00           -0.004458          -0.007690   \n",
       "2015-11-27 00:00:00+00:00            0.004478          -0.000257   \n",
       "2015-11-30 00:00:00+00:00            0.009348           0.005294   \n",
       "2015-12-01 00:00:00+00:00            0.011075           0.002821   \n",
       "2015-12-02 00:00:00+00:00           -0.024693          -0.028571   \n",
       "2015-12-03 00:00:00+00:00           -0.010820          -0.014327   \n",
       "2015-12-04 00:00:00+00:00            0.010326           0.005736   \n",
       "2015-12-07 00:00:00+00:00           -0.008791          -0.026122   \n",
       "2015-12-08 00:00:00+00:00           -0.003910          -0.028251   \n",
       "2015-12-09 00:00:00+00:00           -0.009934           0.013390   \n",
       "2015-12-10 00:00:00+00:00            0.001883           0.000798   \n",
       "2015-12-11 00:00:00+00:00           -0.012713          -0.017840   \n",
       "2015-12-14 00:00:00+00:00           -0.000941           0.022738   \n",
       "2015-12-15 00:00:00+00:00            0.013516           0.044710   \n",
       "2015-12-16 00:00:00+00:00            0.000531          -0.003522   \n",
       "2015-12-17 00:00:00+00:00           -0.018147          -0.015037   \n",
       "2015-12-18 00:00:00+00:00           -0.012314          -0.008724   \n",
       "2015-12-21 00:00:00+00:00            0.016776          -0.000255   \n",
       "2015-12-22 00:00:00+00:00            0.002735           0.005054   \n",
       "2015-12-23 00:00:00+00:00            0.009501           0.032702   \n",
       "2015-12-24 00:00:00+00:00           -0.000620          -0.010724   \n",
       "2015-12-28 00:00:00+00:00           -0.001064          -0.007439   \n",
       "2015-12-29 00:00:00+00:00            0.007964           0.005336   \n",
       "2015-12-30 00:00:00+00:00           -0.007064          -0.013261   \n",
       "2015-12-31 00:00:00+00:00           -0.018175          -0.002050   \n",
       "2016-01-04 00:00:00+00:00           -0.024922          -0.006276   \n",
       "2016-01-05 00:00:00+00:00            0.014863           0.008511   \n",
       "\n",
       "                           Equity(484 [XRAY])  Equity(485 [XRX])  \\\n",
       "2011-01-07 00:00:00+00:00           -0.004044          -0.013953   \n",
       "2011-01-10 00:00:00+00:00            0.010466           0.009733   \n",
       "2011-01-11 00:00:00+00:00            0.007351           0.006116   \n",
       "2011-01-12 00:00:00+00:00            0.027182           0.004386   \n",
       "2011-01-13 00:00:00+00:00            0.000547          -0.018235   \n",
       "2011-01-14 00:00:00+00:00           -0.000287           0.026494   \n",
       "2011-01-18 00:00:00+00:00            0.011589           0.006044   \n",
       "2011-01-19 00:00:00+00:00           -0.019899          -0.012847   \n",
       "2011-01-20 00:00:00+00:00           -0.000841          -0.033798   \n",
       "2011-01-21 00:00:00+00:00           -0.003048          -0.000872   \n",
       "2011-01-24 00:00:00+00:00            0.001660           0.008049   \n",
       "2011-01-25 00:00:00+00:00            0.001134           0.015143   \n",
       "2011-01-26 00:00:00+00:00            0.000552          -0.076291   \n",
       "2011-01-27 00:00:00+00:00            0.016396           0.024664   \n",
       "2011-01-28 00:00:00+00:00           -0.021871          -0.022229   \n",
       "2011-01-31 00:00:00+00:00           -0.007560           0.006615   \n",
       "2011-02-01 00:00:00+00:00            0.024795           0.024498   \n",
       "2011-02-02 00:00:00+00:00           -0.010390          -0.001827   \n",
       "2011-02-03 00:00:00+00:00            0.008556           0.004596   \n",
       "2011-02-04 00:00:00+00:00            0.003048          -0.005506   \n",
       "2011-02-07 00:00:00+00:00            0.006852           0.002768   \n",
       "2011-02-08 00:00:00+00:00            0.005182          -0.002761   \n",
       "2011-02-09 00:00:00+00:00           -0.018441           0.003705   \n",
       "2011-02-10 00:00:00+00:00            0.005512          -0.004624   \n",
       "2011-02-11 00:00:00+00:00            0.007147           0.012021   \n",
       "2011-02-14 00:00:00+00:00           -0.005443           0.005476   \n",
       "2011-02-15 00:00:00+00:00            0.004097           0.003604   \n",
       "2011-02-16 00:00:00+00:00            0.000285           0.027093   \n",
       "2011-02-17 00:00:00+00:00           -0.001911           0.000000   \n",
       "2011-02-18 00:00:00+00:00            0.013148          -0.004390   \n",
       "...                                       ...                ...   \n",
       "2015-11-20 00:00:00+00:00            0.002793           0.002899   \n",
       "2015-11-23 00:00:00+00:00            0.007345           0.027692   \n",
       "2015-11-24 00:00:00+00:00           -0.009563          -0.012992   \n",
       "2015-11-25 00:00:00+00:00           -0.002792          -0.001913   \n",
       "2015-11-27 00:00:00+00:00            0.002633           0.003795   \n",
       "2015-11-30 00:00:00+00:00           -0.007363          -0.007524   \n",
       "2015-12-01 00:00:00+00:00            0.021600           0.013276   \n",
       "2015-12-02 00:00:00+00:00            0.007572          -0.029962   \n",
       "2015-12-03 00:00:00+00:00            0.002733          -0.000959   \n",
       "2015-12-04 00:00:00+00:00            0.007495           0.011599   \n",
       "2015-12-07 00:00:00+00:00           -0.001900          -0.029576   \n",
       "2015-12-08 00:00:00+00:00           -0.012067          -0.004930   \n",
       "2015-12-09 00:00:00+00:00           -0.021066          -0.009869   \n",
       "2015-12-10 00:00:00+00:00           -0.000317           0.014970   \n",
       "2015-12-11 00:00:00+00:00           -0.017755          -0.012793   \n",
       "2015-12-14 00:00:00+00:00           -0.001835          -0.017913   \n",
       "2015-12-15 00:00:00+00:00            0.004357           0.016222   \n",
       "2015-12-16 00:00:00+00:00            0.008507           0.024937   \n",
       "2015-12-17 00:00:00+00:00           -0.003142          -0.007787   \n",
       "2015-12-18 00:00:00+00:00           -0.010451          -0.003944   \n",
       "2015-12-21 00:00:00+00:00            0.007035           0.014779   \n",
       "2015-12-22 00:00:00+00:00            0.010047           0.038863   \n",
       "2015-12-23 00:00:00+00:00            0.007586           0.011193   \n",
       "2015-12-24 00:00:00+00:00           -0.002127           0.005553   \n",
       "2015-12-28 00:00:00+00:00            0.004930          -0.021138   \n",
       "2015-12-29 00:00:00+00:00            0.011436           0.011283   \n",
       "2015-12-30 00:00:00+00:00           -0.008079           0.001847   \n",
       "2015-12-31 00:00:00+00:00           -0.009119          -0.008371   \n",
       "2016-01-04 00:00:00+00:00           -0.032711          -0.031051   \n",
       "2016-01-05 00:00:00+00:00            0.020390          -0.001957   \n",
       "\n",
       "                           Equity(486 [XYL])  Equity(487 [YUM])  \\\n",
       "2011-01-07 00:00:00+00:00           0.000000           0.012457   \n",
       "2011-01-10 00:00:00+00:00           0.000000           0.001440   \n",
       "2011-01-11 00:00:00+00:00           0.000000          -0.006470   \n",
       "2011-01-12 00:00:00+00:00           0.000000           0.002631   \n",
       "2011-01-13 00:00:00+00:00           0.000000          -0.005084   \n",
       "2011-01-14 00:00:00+00:00           0.000000          -0.021661   \n",
       "2011-01-18 00:00:00+00:00           0.000000           0.029453   \n",
       "2011-01-19 00:00:00+00:00           0.000000           0.000818   \n",
       "2011-01-20 00:00:00+00:00           0.000000          -0.013182   \n",
       "2011-01-21 00:00:00+00:00           0.000000          -0.007590   \n",
       "2011-01-24 00:00:00+00:00           0.000000           0.000601   \n",
       "2011-01-25 00:00:00+00:00           0.000000          -0.006208   \n",
       "2011-01-26 00:00:00+00:00           0.000000          -0.004803   \n",
       "2011-01-27 00:00:00+00:00           0.000000          -0.003746   \n",
       "2011-01-28 00:00:00+00:00           0.000000          -0.025001   \n",
       "2011-01-31 00:00:00+00:00           0.000000           0.007748   \n",
       "2011-02-01 00:00:00+00:00           0.000000           0.014102   \n",
       "2011-02-02 00:00:00+00:00           0.000000           0.006562   \n",
       "2011-02-03 00:00:00+00:00           0.000000           0.031413   \n",
       "2011-02-04 00:00:00+00:00           0.000000           0.001408   \n",
       "2011-02-07 00:00:00+00:00           0.000000           0.002028   \n",
       "2011-02-08 00:00:00+00:00           0.000000           0.003851   \n",
       "2011-02-09 00:00:00+00:00           0.000000          -0.001821   \n",
       "2011-02-10 00:00:00+00:00           0.000000           0.004853   \n",
       "2011-02-11 00:00:00+00:00           0.000000           0.000616   \n",
       "2011-02-14 00:00:00+00:00           0.000000           0.010657   \n",
       "2011-02-15 00:00:00+00:00           0.000000           0.008526   \n",
       "2011-02-16 00:00:00+00:00           0.000000           0.008898   \n",
       "2011-02-17 00:00:00+00:00           0.000000           0.003906   \n",
       "2011-02-18 00:00:00+00:00           0.000000          -0.004110   \n",
       "...                                      ...                ...   \n",
       "2015-11-20 00:00:00+00:00          -0.004498           0.015060   \n",
       "2015-11-23 00:00:00+00:00           0.001322          -0.000966   \n",
       "2015-11-24 00:00:00+00:00          -0.001871          -0.004252   \n",
       "2015-11-25 00:00:00+00:00           0.004824           0.002894   \n",
       "2015-11-27 00:00:00+00:00          -0.002140           0.005105   \n",
       "2015-11-30 00:00:00+00:00          -0.006928          -0.006183   \n",
       "2015-12-01 00:00:00+00:00           0.008582           0.027170   \n",
       "2015-12-02 00:00:00+00:00          -0.018335           0.006313   \n",
       "2015-12-03 00:00:00+00:00          -0.005676          -0.024272   \n",
       "2015-12-04 00:00:00+00:00           0.024774           0.041159   \n",
       "2015-12-07 00:00:00+00:00          -0.019647           0.003540   \n",
       "2015-12-08 00:00:00+00:00          -0.017074          -0.010735   \n",
       "2015-12-09 00:00:00+00:00          -0.000570          -0.023679   \n",
       "2015-12-10 00:00:00+00:00           0.012138          -0.008256   \n",
       "2015-12-11 00:00:00+00:00          -0.013062          -0.025836   \n",
       "2015-12-14 00:00:00+00:00           0.011580           0.004910   \n",
       "2015-12-15 00:00:00+00:00           0.001635           0.013410   \n",
       "2015-12-16 00:00:00+00:00           0.020719           0.012809   \n",
       "2015-12-17 00:00:00+00:00          -0.026697          -0.018224   \n",
       "2015-12-18 00:00:00+00:00          -0.017002          -0.004991   \n",
       "2015-12-21 00:00:00+00:00           0.008360           0.021714   \n",
       "2015-12-22 00:00:00+00:00           0.009977          -0.005448   \n",
       "2015-12-23 00:00:00+00:00           0.017237           0.015349   \n",
       "2015-12-24 00:00:00+00:00          -0.001614          -0.001620   \n",
       "2015-12-28 00:00:00+00:00          -0.003484          -0.002177   \n",
       "2015-12-29 00:00:00+00:00           0.004307           0.005415   \n",
       "2015-12-30 00:00:00+00:00          -0.006182          -0.005781   \n",
       "2015-12-31 00:00:00+00:00          -0.010031          -0.010299   \n",
       "2016-01-04 00:00:00+00:00          -0.011520          -0.011489   \n",
       "2016-01-05 00:00:00+00:00          -0.000286          -0.002495   \n",
       "\n",
       "                           Equity(488 [ZBH])  Equity(489 [ZION])  \\\n",
       "2011-01-07 00:00:00+00:00          -0.000181           -0.010458   \n",
       "2011-01-10 00:00:00+00:00           0.007784           -0.017945   \n",
       "2011-01-11 00:00:00+00:00           0.035676            0.007467   \n",
       "2011-01-12 00:00:00+00:00           0.014741           -0.011903   \n",
       "2011-01-13 00:00:00+00:00          -0.004665           -0.009178   \n",
       "2011-01-14 00:00:00+00:00           0.005949            0.033177   \n",
       "2011-01-18 00:00:00+00:00           0.006998           -0.008534   \n",
       "2011-01-19 00:00:00+00:00          -0.004098           -0.018433   \n",
       "2011-01-20 00:00:00+00:00          -0.001612           -0.007972   \n",
       "2011-01-21 00:00:00+00:00           0.009325            0.024020   \n",
       "2011-01-24 00:00:00+00:00          -0.016501           -0.023021   \n",
       "2011-01-25 00:00:00+00:00           0.017142           -0.008836   \n",
       "2011-01-26 00:00:00+00:00          -0.019524           -0.010626   \n",
       "2011-01-27 00:00:00+00:00           0.068754            0.020160   \n",
       "2011-01-28 00:00:00+00:00          -0.008472           -0.013873   \n",
       "2011-01-31 00:00:00+00:00           0.009902            0.006378   \n",
       "2011-02-01 00:00:00+00:00           0.017746            0.030970   \n",
       "2011-02-02 00:00:00+00:00           0.005161           -0.003706   \n",
       "2011-02-03 00:00:00+00:00          -0.000333           -0.000394   \n",
       "2011-02-04 00:00:00+00:00           0.002471            0.016111   \n",
       "2011-02-07 00:00:00+00:00          -0.010876            0.027617   \n",
       "2011-02-08 00:00:00+00:00          -0.000495            0.004780   \n",
       "2011-02-09 00:00:00+00:00          -0.009851           -0.004757   \n",
       "2011-02-10 00:00:00+00:00           0.011449           -0.026498   \n",
       "2011-02-11 00:00:00+00:00           0.009660            0.014256   \n",
       "2011-02-14 00:00:00+00:00           0.002484           -0.010021   \n",
       "2011-02-15 00:00:00+00:00          -0.001815           -0.004461   \n",
       "2011-02-16 00:00:00+00:00           0.010557            0.001206   \n",
       "2011-02-17 00:00:00+00:00           0.015325           -0.003227   \n",
       "2011-02-18 00:00:00+00:00           0.023782           -0.017960   \n",
       "...                                      ...                 ...   \n",
       "2015-11-20 00:00:00+00:00          -0.003176            0.000000   \n",
       "2015-11-23 00:00:00+00:00          -0.008581           -0.001992   \n",
       "2015-11-24 00:00:00+00:00          -0.009043            0.002650   \n",
       "2015-11-25 00:00:00+00:00          -0.006174           -0.000309   \n",
       "2015-11-27 00:00:00+00:00          -0.002869            0.005013   \n",
       "2015-11-30 00:00:00+00:00           0.000101           -0.004339   \n",
       "2015-12-01 00:00:00+00:00           0.016927            0.015028   \n",
       "2015-12-02 00:00:00+00:00          -0.004473           -0.015448   \n",
       "2015-12-03 00:00:00+00:00          -0.028367           -0.015725   \n",
       "2015-12-04 00:00:00+00:00           0.011977            0.024452   \n",
       "2015-12-07 00:00:00+00:00          -0.001384           -0.042085   \n",
       "2015-12-08 00:00:00+00:00          -0.006277           -0.031813   \n",
       "2015-12-09 00:00:00+00:00           0.002205           -0.007490   \n",
       "2015-12-10 00:00:00+00:00          -0.000297            0.014759   \n",
       "2015-12-11 00:00:00+00:00          -0.010112           -0.029782   \n",
       "2015-12-14 00:00:00+00:00           0.005356           -0.014991   \n",
       "2015-12-15 00:00:00+00:00           0.015787            0.035626   \n",
       "2015-12-16 00:00:00+00:00           0.008606            0.010755   \n",
       "2015-12-17 00:00:00+00:00          -0.011966           -0.015960   \n",
       "2015-12-18 00:00:00+00:00          -0.017384           -0.037845   \n",
       "2015-12-21 00:00:00+00:00           0.012842            0.002271   \n",
       "2015-12-22 00:00:00+00:00           0.014966            0.014553   \n",
       "2015-12-23 00:00:00+00:00           0.010219            0.018773   \n",
       "2015-12-24 00:00:00+00:00           0.001364            0.003975   \n",
       "2015-12-28 00:00:00+00:00          -0.006413           -0.005033   \n",
       "2015-12-29 00:00:00+00:00           0.007235            0.006174   \n",
       "2015-12-30 00:00:00+00:00          -0.002921           -0.012235   \n",
       "2015-12-31 00:00:00+00:00           0.001176           -0.006212   \n",
       "2016-01-04 00:00:00+00:00          -0.007604           -0.021614   \n",
       "2016-01-05 00:00:00+00:00           0.020820           -0.010853   \n",
       "\n",
       "                           Equity(490 [ZTS])  \n",
       "2011-01-07 00:00:00+00:00           0.000000  \n",
       "2011-01-10 00:00:00+00:00           0.000000  \n",
       "2011-01-11 00:00:00+00:00           0.000000  \n",
       "2011-01-12 00:00:00+00:00           0.000000  \n",
       "2011-01-13 00:00:00+00:00           0.000000  \n",
       "2011-01-14 00:00:00+00:00           0.000000  \n",
       "2011-01-18 00:00:00+00:00           0.000000  \n",
       "2011-01-19 00:00:00+00:00           0.000000  \n",
       "2011-01-20 00:00:00+00:00           0.000000  \n",
       "2011-01-21 00:00:00+00:00           0.000000  \n",
       "2011-01-24 00:00:00+00:00           0.000000  \n",
       "2011-01-25 00:00:00+00:00           0.000000  \n",
       "2011-01-26 00:00:00+00:00           0.000000  \n",
       "2011-01-27 00:00:00+00:00           0.000000  \n",
       "2011-01-28 00:00:00+00:00           0.000000  \n",
       "2011-01-31 00:00:00+00:00           0.000000  \n",
       "2011-02-01 00:00:00+00:00           0.000000  \n",
       "2011-02-02 00:00:00+00:00           0.000000  \n",
       "2011-02-03 00:00:00+00:00           0.000000  \n",
       "2011-02-04 00:00:00+00:00           0.000000  \n",
       "2011-02-07 00:00:00+00:00           0.000000  \n",
       "2011-02-08 00:00:00+00:00           0.000000  \n",
       "2011-02-09 00:00:00+00:00           0.000000  \n",
       "2011-02-10 00:00:00+00:00           0.000000  \n",
       "2011-02-11 00:00:00+00:00           0.000000  \n",
       "2011-02-14 00:00:00+00:00           0.000000  \n",
       "2011-02-15 00:00:00+00:00           0.000000  \n",
       "2011-02-16 00:00:00+00:00           0.000000  \n",
       "2011-02-17 00:00:00+00:00           0.000000  \n",
       "2011-02-18 00:00:00+00:00           0.000000  \n",
       "...                                      ...  \n",
       "2015-11-20 00:00:00+00:00           0.008950  \n",
       "2015-11-23 00:00:00+00:00          -0.007600  \n",
       "2015-11-24 00:00:00+00:00          -0.000651  \n",
       "2015-11-25 00:00:00+00:00           0.000868  \n",
       "2015-11-27 00:00:00+00:00           0.002343  \n",
       "2015-11-30 00:00:00+00:00          -0.008071  \n",
       "2015-12-01 00:00:00+00:00           0.006632  \n",
       "2015-12-02 00:00:00+00:00          -0.013610  \n",
       "2015-12-03 00:00:00+00:00          -0.025244  \n",
       "2015-12-04 00:00:00+00:00           0.027882  \n",
       "2015-12-07 00:00:00+00:00          -0.011841  \n",
       "2015-12-08 00:00:00+00:00           0.000666  \n",
       "2015-12-09 00:00:00+00:00          -0.015900  \n",
       "2015-12-10 00:00:00+00:00           0.019695  \n",
       "2015-12-11 00:00:00+00:00          -0.005856  \n",
       "2015-12-14 00:00:00+00:00           0.016583  \n",
       "2015-12-15 00:00:00+00:00           0.008156  \n",
       "2015-12-16 00:00:00+00:00           0.002538  \n",
       "2015-12-17 00:00:00+00:00          -0.007637  \n",
       "2015-12-18 00:00:00+00:00          -0.002791  \n",
       "2015-12-21 00:00:00+00:00           0.015894  \n",
       "2015-12-22 00:00:00+00:00           0.008027  \n",
       "2015-12-23 00:00:00+00:00           0.005444  \n",
       "2015-12-24 00:00:00+00:00           0.003121  \n",
       "2015-12-28 00:00:00+00:00          -0.004784  \n",
       "2015-12-29 00:00:00+00:00           0.008997  \n",
       "2015-12-30 00:00:00+00:00          -0.001454  \n",
       "2015-12-31 00:00:00+00:00          -0.007051  \n",
       "2016-01-04 00:00:00+00:00          -0.013564  \n",
       "2016-01-05 00:00:00+00:00           0.015647  \n",
       "\n",
       "[1256 rows x 490 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "returns_df = \\\n",
    "    get_pricing(\n",
    "        data_portal,\n",
    "        trading_calendar,\n",
    "        universe_tickers,\n",
    "        universe_end_date - pd.DateOffset(years=5),\n",
    "        universe_end_date)\\\n",
    "    .pct_change()[1:].fillna(0) #convert prices into returns\n",
    "\n",
    "returns_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Let's look at a two stock portfolio\n",
    "\n",
    "Let's pretend we have a portfolio of two stocks.  We'll pick Apple and Microsoft in this example."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asset_return_aapl</th>\n",
       "      <th>asset_return_msft</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2011-01-07 00:00:00+00:00</th>\n",
       "      <td>0.007146</td>\n",
       "      <td>-0.007597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-10 00:00:00+00:00</th>\n",
       "      <td>0.018852</td>\n",
       "      <td>-0.013311</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           asset_return_aapl  asset_return_msft\n",
       "2011-01-07 00:00:00+00:00           0.007146          -0.007597\n",
       "2011-01-10 00:00:00+00:00           0.018852          -0.013311"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aapl_col = returns_df.columns[3]\n",
    "msft_col = returns_df.columns[312]\n",
    "asset_return_1 = returns_df[aapl_col].rename('asset_return_aapl')\n",
    "asset_return_2 = returns_df[msft_col].rename('asset_return_msft')\n",
    "asset_return_df = pd.concat([asset_return_1,asset_return_2],axis=1)\n",
    "asset_return_df.head(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Factor returns\n",
    "Let's make up a \"factor\" by taking an average of all stocks in our list.  You can think of this as an equal weighted index of the 490 stocks, kind of like a measure of the \"market\".  We'll also make another factor by calculating the median of all the stocks.  These are mainly intended to help us generate some data to work with.  We'll go into how some common risk factors are generated later in the lessons.\n",
    "\n",
    "Also note that we're setting axis=1 so that we calculate a value for each time period (row) instead of one value for each column (assets)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "factor_return_1 = returns_df.mean(axis=1)\n",
    "factor_return_2 = returns_df.median(axis=1)\n",
    "factor_return_l = [factor_return_1, factor_return_2]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Factor exposures\n",
    "\n",
    "Factor exposures refer to how \"exposed\" a stock is to each factor.  We'll get into this more later.  For now, just think of this as one number for each stock, for each of the factors."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import LinearRegression"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\"\n",
    "For now, just assume that we're calculating a number for each \n",
    "stock, for each factor, which represents how \"exposed\" each stock is\n",
    "to each factor. \n",
    "We'll discuss how factor exposure is calculated later in the lessons.\n",
    "\"\"\"\n",
    "def get_factor_exposures(factor_return_l, asset_return):\n",
    "    lr = LinearRegression()\n",
    "    X = np.array(factor_return_l).T\n",
    "    y = np.array(asset_return.values)\n",
    "    lr.fit(X,y)\n",
    "    return lr.coef_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "factor_exposure_l = []\n",
    "for i in range(len(asset_return_df.columns)):\n",
    "    factor_exposure_l.append(\n",
    "        get_factor_exposures(factor_return_l,\n",
    "                             asset_return_df[asset_return_df.columns[i]]\n",
    "                            ))\n",
    "    \n",
    "factor_exposure_a = np.array(factor_exposure_l)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "factor_exposures for asset 1 [ 1.35101534 -0.58353198]\n",
      "factor_exposures for asset 2 [-0.2283345   1.16364007]\n"
     ]
    }
   ],
   "source": [
    "print(f\"factor_exposures for asset 1 {factor_exposure_a[0]}\")\n",
    "print(f\"factor_exposures for asset 2 {factor_exposure_a[1]}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Quiz: Variance of stock 1\n",
    "\n",
    "Calculate the variance of stock 1.  \n",
    "$\\textrm{Var}(f_{1}) = \\beta_{1,1}^2 \\textrm{Var}(f_{1}) + \\beta_{1,2}^2 \\textrm{Var}(f_{2}) + 2\\beta_{1,1}\\beta_{1,2}\\textrm{Cov}(f_{1},f_{2}) + \\textrm{Var}(s_{1})$"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "factor_exposure_1_1 = factor_exposure_a[0][0]\n",
    "factor_exposure_1_2 = factor_exposure_a[0][1]\n",
    "common_return_1 = factor_exposure_1_1 * factor_return_1 + factor_exposure_1_2 * factor_return_2\n",
    "specific_return_1 = asset_return_1 - common_return_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "variance of asset 1: 0.00028209\n"
     ]
    }
   ],
   "source": [
    "covm_f1_f2 = np.cov(factor_return_1,factor_return_2,ddof=1) #this calculates a covariance matrix\n",
    "# TODO: get the variance of each factor, and covariances from the covariance matrix covm_f1_f2\n",
    "var_f1 = covm_f1_f2[0,0]\n",
    "var_f2 = covm_f1_f2[1,1]\n",
    "cov_f1_f2 = covm_f1_f2[0][1]\n",
    "\n",
    "# TODO: calculate the specific variance.  \n",
    "var_s_1 = np.var(specific_return_1,ddof=1)\n",
    "\n",
    "# TODO: calculate the variance of asset 1 in terms of the factors and specific variance\n",
    "var_asset_1 = (factor_exposure_1_1**2 * var_f1) + \\\n",
    "              (factor_exposure_1_2**2 * var_f2) + \\\n",
    "              2 * (factor_exposure_1_1 * factor_exposure_1_2 * cov_f1_f2) + \\\n",
    "              var_s_1\n",
    "print(f\"variance of asset 1: {var_asset_1:.8f}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Quiz 2: Variance of stock 2\n",
    "Calculate the variance of stock 2.  \n",
    "$\\textrm{Var}(f_{2}) = \\beta_{2,1}^2 \\textrm{Var}(f_{1}) + \\beta_{2,2}^2 \\textrm{Var}(f_{2}) + 2\\beta_{2,1}\\beta_{2,2}\\textrm{Cov}(f_{1},f_{2}) + \\textrm{Var}(s_{2})$"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "factor_exposure_2_1 = factor_exposure_a[1][0]\n",
    "factor_exposure_2_2 = factor_exposure_a[1][1]\n",
    "common_return_2 = factor_exposure_2_1 * factor_return_1 + factor_exposure_2_2 * factor_return_2\n",
    "specific_return_2 = asset_return_2 - common_return_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "variance of asset 2: 0.00021856\n"
     ]
    }
   ],
   "source": [
    "# Notice we already calculated the variance and covariances of the factors\n",
    "\n",
    "# TODO: calculate the specific variance of asset 2\n",
    "var_s_2 = np.var(specific_return_2,ddof=1)\n",
    "\n",
    "# TODO: calcualte the variance of asset 2 in terms of the factors and specific variance\n",
    "var_asset_2 = (factor_exposure_2_1**2 * var_f1) + \\\n",
    "              (factor_exposure_2_2**2 * var_f2) + \\\n",
    "              (2 * factor_exposure_2_1 * factor_exposure_2_2 * cov_f1_f2) + \\\n",
    "              var_s_2\n",
    "            \n",
    "print(f\"variance of asset 2: {var_asset_2:.8f}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Quiz 3: Covariance of stocks 1 and 2\n",
    "Calculate the covariance of stock 1 and 2.  \n",
    "$\\textrm{Cov}(f_{1},f_{2}) = \\beta_{1,1}\\beta_{2,1}\\textrm{Var}(f_{1}) + \\beta_{1,1}\\beta_{2,2}\\textrm{Cov}(f_{1},f_{2}) + \\beta_{1,2}\\beta_{2,1}\\textrm{Cov}(f_{1},f_{2}) + \\beta_{1,2}\\beta_{2,2}\\textrm{Var}(f_{2})$"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "covariance of assets 1 and 2: 0.00007133\n"
     ]
    }
   ],
   "source": [
    "# TODO: calculate the covariance of assets 1 and 2 in terms of the factors\n",
    "cov_asset_1_2 = (factor_exposure_1_1 * factor_exposure_2_1 * var_f1) + \\\n",
    "            (factor_exposure_1_1 * factor_exposure_2_2 * cov_f1_f2) + \\\n",
    "            (factor_exposure_1_2 * factor_exposure_2_1 * cov_f1_f2) + \\\n",
    "            (factor_exposure_1_2 * factor_exposure_2_2 * var_f2)\n",
    "print(f\"covariance of assets 1 and 2: {cov_asset_1_2:.8f}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Quiz 4: Do it with Matrices!\n",
    "\n",
    "Create matrices $\\mathbf{F}$, $\\mathbf{B}$ and $\\mathbf{S}$, where  \n",
    "$\\mathbf{F}= \\begin{pmatrix}\n",
    "\\textrm{Var}(f_1) & \\textrm{Cov}(f_1,f_2) \\\\ \n",
    "\\textrm{Cov}(f_2,f_1) & \\textrm{Var}(f_2) \n",
    "\\end{pmatrix}$\n",
    "is the covariance matrix of factors,  \n",
    "\n",
    "$\\mathbf{B} = \\begin{pmatrix}\n",
    "\\beta_{1,1}, \\beta_{1,2}\\\\ \n",
    "\\beta_{2,1}, \\beta_{2,2}\n",
    "\\end{pmatrix}$ \n",
    "is the matrix of factor exposures, and  \n",
    "\n",
    "$\\mathbf{S} = \\begin{pmatrix}\n",
    "\\textrm{Var}(s_i) & 0\\\\ \n",
    "0 & \\textrm{Var}(s_j)\n",
    "\\end{pmatrix}$\n",
    "is the matrix of specific variances.  \n",
    "\n",
    "Then calculate $\\mathbf{BFB}^T$ "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[1.02562520e-04, 9.79887017e-05],\n",
       "       [9.79887017e-05, 9.44523986e-05]])"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# TODO: covariance matrix of factors\n",
    "F = covm_f1_f2\n",
    "F"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[ 1.35101534, -0.58353198],\n",
       "       [-0.2283345 ,  1.16364007]])"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# TODO: matrix of factor exposures\n",
    "B = factor_exposure_a\n",
    "B"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Hint: for diagonal matrices\n",
    "You can try using [numpy.diag](https://docs.scipy.org/doc/numpy-1.15.1/reference/generated/numpy.diag.html)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0.00021723, 0.        ],\n",
       "       [0.        , 0.00013739]])"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# TODO: matrix of specific variances\n",
    "S = np.diag([var_s_1,var_s_2])\n",
    "S"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "covariance matrix of assets 1 and 2 \n",
      "[[2.82089786e-04 7.13296510e-05]\n",
      " [7.13296510e-05 2.18561378e-04]]\n"
     ]
    }
   ],
   "source": [
    "# TODO: covariance matrix of assets\n",
    "covm_assets = B.dot(F).dot(B.T) + S\n",
    "print(f\"covariance matrix of assets 1 and 2 \\n{covm_assets}\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
